As you enter data into cells in your Excel worksheet, you may notice that your rows change height - which can lead to a sloppy presentation if you're sharing There's a quick way to do this. Simply select and right click the row (or column) and choose Row Height (or Column Width): You'll see a dialog. Like me you probably thought you knew how to do this! And then I had to use my get out of jail free excuse of 'Well that's how you used to do it in Office 2010. I'll go and check that out and get back to you as soon as I can'. Using a lot of Google-Fu I finally managed to piece together enough info to sort it out. I'm guessing that this also works in Office 2013. The pictures are from the Dutch version of Office but I'm sure you can work it out! * edit I added in some Dutch subtitles to make it a bit easier! Once you have done this you only need to follow steps 4 and 5 to repeat the process in a different document. Unless of course you want to change to a different unit of measurement:). Trend micro antivirus internet security 2017 for mac. ![]() I apologize if this question has been asked before. I created a business quotation in Excel for Mac 2011 and adjusted all the columns and rows so that it fits into a page nicely. However, after saving this file and opening it in Excel 2007/2010 for PC, all the columns and rows were of different sizes and the formatting is totally off. The same thing happens when I try to resize the columns and rows on Excel for PC then opening the file on Excel for Mac. How do I fix this problem? I have users in the company using Excel on both Macs and PCs. • choose the same standard fonts & widths as the creator of the workbook • stick to fonts that Microsoft shipped with Office 2011 (older versions, or versions produced by other manufacturers, even with the same name, may have different metrics). • choose common fonts in the worksheet (if the user doesn't have a particular font, XL will choose the 'closest', which may not be close enough - and it won't tell you what substitution it made.) • Use the same printer/printer drivers • Keep your print drivers updated • Be careful using scaling: Page Setup/Page/Fit to x page(s) wide by y page(s) tall - different drivers can come up with wildly different settings.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |