![]() ![]() 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. 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. PC Shorcut:Ctrl+Shift+& Mac Shorcut:++0 Add Or Remove Top Border This Excel Shortcut adds or removes the Top Border. 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. Add Outline Border This Excel Shortcut adds an Outline Border. How did you two come up with this way of doing things? Once the range of cells or cell is mentioned we need to access the VBA Borders Around method. One of th characters we ned to use hre is Line StyIe, so select th Line Style proprty. 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. For example, if you want to change the border of the cell B5 then you can write the code like this. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |