![]() 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. Open Page Layout In Excel 2007, click the Page Layout tab, then click the small arrow in the bottom right corner of the Page Setup group (this also works for Excel 2010 as an alternative to the instructions above) In earlier versions of Excel, and for Excel 2008 and. But the system you describe sounds maddeningly over-engineered to me. If you're using Excel 2007 and earlier for PC, or Excel for Mac 2008 or 2011. ![]() ![]() ![]() Or you could let your supervisor write on a hard copy and you type the changes. Locate on Edit menu Paste Special Click only on: Formulas, Formula and Number Formats, Values and Number Formats. This Selects entire work sheet contents you know about. Or your supervisor should get/learn Excel and “edit” your sheet when you turn it in. Starting in top left corner of sheet, hold shift key down and scroll to the last Cell you use on Bottom right and Click again. 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 |