Formatting all sheets at once

Resolved · Medium Priority · Version 2013

Thu 9 Jul 2015, 17:27 Delegate Rob said...

Rob has attended:
Excel Intermediate course

Formatting all sheets at once

I learned about formatting all sheets on my intermediate course at the same time. However, I'm working with multiple sheets where two are different. Is it possible to exclude a sheet or two when using this function?
Many thanks
Rob

Thu 9 Jul 2015, 19:11 Trainer Doug said...

RE: Formatting all sheets at once

Hi Rob

Yes. First select all the sheets (Right click on a tab, Select All Sheets)
Then keeping the Ctrl key pressed click on the tabs you don't want included.

Cheers

Doug
Best STL

Fri 10 Jul 2015, 08:06 Delegate Rob said...

RE: Formatting all sheets at once

Hi Doug, and thank you.
Rob

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips