ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Format Checking (https://www.excelbanter.com/excel-discussion-misc-queries/223602-format-checking.html)

George

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?

Sheeloo[_3_]

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