Format Checking

  • Thread starter Thread starter George
  • Start date Start date
G

George

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?
 
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.
 
Back
Top