![]() ![]() 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. But the system you describe sounds maddeningly over-engineered to me. The subsequent cells are non-blank cells and the. And this time, you can see our column width decreased to accommodate the contents. Select the column (s), click the Format drop-down arrow on the Home tab, and pick AutoFit Column Width as described above. When you have text in a cell that is too long to fit within the width of the cell, you can use the Wrap Text command to make the text automatically wrap to. Or you could let your supervisor write on a hard copy and you type the changes. The height or width may have been preset which is why the added text wont make the cell expand accordingly. We can gain some space in our sheet by making the cells smaller to fit the text. For the template document as far as I understood the only way to format the. Or your supervisor should get/learn Excel and “edit” your sheet when you turn it in. When Exporting a table to excel make the Print layout all to one page. If you adjust the column to be a little bit wider and double click between the rows it will. 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. Its because the text ends too close to the right edge of the cell. 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 |