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. Note: make sure you have Wrap Text enabled on cells that contain line breaks. The result of the concatenation is text with line breaks: Traci Brown¬ 1301 Robinson Court¬ Saginaw, MI 48607. On Windows, the code is 10 and on a Mac its 13. Click the location inside the selected cell where you want to break the line. ![]() Double-click the cell in which you want to insert a line break (or select the cell and then press F2). ![]() But the system you describe sounds maddeningly over-engineered to me. The character code for a line break in Excel varies depending on the platform. To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, press Alt+Enter to insert a line break. Or you could let your supervisor write on a hard copy and you type the changes. 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? ![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |