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. This will automatically adjust the column width to fit the longest entry in that column. Simply select the column you want to adjust, then press the Alt key and the H key, followed by the O key. Step 3 Text Wraped Vertically The text will be wraped vertically without changing the column width. Step 2 Go To The Home Tab Go to the home tab, under the alignment group click on the Wrap Text button. Click where you want to insert a line break, and then press CONTROL + OPTION + RETURN. Step 1 Select Data Select the data which you want to wrap. Start a new line in the cell Inserting a line break may make text in a cell easier to read. But the system you describe sounds maddeningly over-engineered to me. AutoFit Column Width The easiest way to expand a column to fit its contents is to use the AutoFit Column Width shortcut. To enable the row to adjust automatically and show all wrapped text, on the Format menu, point to Row, and then click AutoFit. Or you could let your supervisor write on a hard copy and you type the changes. Rows in Excel are, by default, a uniform size. 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 |