Format Sheets

Parra

Well-known Member
Joined
Feb 21, 2002
Messages
752
How come when I select all the sheets in a workbook and format them. Only the sheet 1 of the sheets is formatted. How can I get all the sheets I select to be formatted?

Thanks

Parra
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Iridium

Well-known Member
Joined
Jul 15, 2002
Messages
2,831
What formatting are you trying to do and how are you doing it? Just tried applying a font type and size change to two selected sheets and that worked...
 

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
are you selecting all your sheets first, then selecting all cells, then formatting? what's your pecking order here? seems to work for me ok.
 

Parra

Well-known Member
Joined
Feb 21, 2002
Messages
752
I am trying to change the margins, fit to 1 page and center horizontal and vertical.

Parra
 

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web

ADVERTISEMENT

in print preview mode, go to setup..., on the page tab under scaling click fit to 1 page wide x 1 page tall, then click the margins tab and under center on page, check horizontally and vertically.
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Worked just fine for me.

How are you selecting all of your sheets? I use CTRL+SHIFT on each worksheet tab.

Smitty
 

Iridium

Well-known Member
Joined
Jul 15, 2002
Messages
2,831

ADVERTISEMENT

Works fine for me - can you post your sheet and whatever page setup options you're trying to set?
 

Parra

Well-known Member
Joined
Feb 21, 2002
Messages
752
I right mouse click and select all the sheets and then format and nothing. It only formats the 1st sheet not the others. What could be wrong. I also tried ctrl-shift to select the sheets and nothing.

Parra
 

Iridium

Well-known Member
Joined
Jul 15, 2002
Messages
2,831
Click on your first sheet, press and hold the SHIFT key then click on your last sheet
 

Watch MrExcel Video

Forum statistics

Threads
1,123,158
Messages
5,600,054
Members
414,357
Latest member
Gemma_R

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top