Flipping the data back and forth among various file types (copying to Word, over to Outlook, then re-copying back to Excel) is bound to cause formatting issues.
When you press the Enter key to complete the entry, the line break appears, and Wrap Text. Press Alt+Enter Press Enter, to complete the entry and move to another cell Wrap Text Added Automatically. The cursor is positioned where the line break should be added. But the system you describe sounds maddeningly over-engineered to me. Here is an example of adding a line break in Excel text. Then press ALT key and hold it down and press the. Or you could let your supervisor write on a hard copy and you type the changes. Optional: To add another line within a cell, press + Enter on a Mac or Ctrl + Enter on Windows. To add a new line of text in a cell of Excel Spreadsheet, you have to place the cursor at the end of line. Or your supervisor should get/learn Excel and “edit” your sheet when you turn it in. It sounds to me like your company needs the services of a good IT professional to set up some sort of environment in which your supervisor has direct access to the data that needs editing. How did you two come up with this way of doing things?
Never fear There's a simple keyboard shortcut that will let you add line. If you've ever tried hitting Enter there, you know it just takes you to the next cell down in your worksheet.
EXCEL ADD NEW LINE IN CELL HOW TO
This may sound a little harsh, but … can your supervisor not simply edit the file in Excel? Does s/he not have Excel? Or has it but doesn’t know how to use it? What’s the barrier to simply attaching the Excel sheet to the outgoing email, rather than dumping the text into the body of the email? I don’t really get how this copy-and-paste process you describe evolved. Line breaks are pretty easy to add in most programsall you have to do is press Enter on your PC keyboard or Return on your Mac keyboard and presto One of the few places line breaks don’t work is Excel.