![]() |
Format Checking
Excel 2007
In the same workbook, I have two sheets - rows, columns, fonts and margins are all the same, but when printed the two sheets are slightly out of line. Is there a way I can compare the two to check what might be different? Is there a way to format all sheets in the workbook the same, at the same time? |
Format Checking
If you mean PAGE SETUP then yes, you can.
Right click on any tab at the bottom of the screen and choose "Select All Sheets' Now do your page setup... it will apply to all sheets. Remember to 'Ungroup Sheets' once you are done setting up your page. "George" wrote: Excel 2007 In the same workbook, I have two sheets - rows, columns, fonts and margins are all the same, but when printed the two sheets are slightly out of line. Is there a way I can compare the two to check what might be different? Is there a way to format all sheets in the workbook the same, at the same time? |
All times are GMT +1. The time now is 04:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com