Format Sheets

[Parra]

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

 

[Iridium]

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]

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]

I am trying to change the margins, fit to 1 page and center horizontal and vertical.

Parra

 

[Zack Barresse]

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]

Worked just fine for me.

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

Smitty

 

[Iridium]

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

 

[Parra]

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]

Click on your first sheet, press and hold the SHIFT key then click on your last sheet