Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

formatting all sheets once

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formatting all sheets at once

Formatting all sheets at once

ResolvedVersion 2013

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

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

RE: Formatting all sheets at once

Hi Doug, and thank you.
Rob

Excel tip:

Change the default location for opening and saving spreadsheets

If you are always opening spreadsheets from and/or saving documents to a specific location that is not My Documents, save time by setting this folder as the default for opening files from and saving files to.

Here's how:
1. Go to Tools - Options.

2. Select the General tab.

3. Enter the pathname of the folder you wish to make the default in the Default File Location box (hint: it will be easier to use Windows Explorer to navigate to this folder, then copy and paste the pathname from the address bar at the top of the Windows Explorer screen).

4. Click OK.

You have now changed the default folder for opening and saving spreadsheets.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.