Easy (?) formating question...

Von Pookie · Mar 7th, 2002, 12:36 PM

I have a workbook with 12 tabs (one for each month).

Each sheet is exactly the same, except for the information that is entered, of course.

I would like the change the font of A3:H80 for all the worksheets. Is there some way I can do this all at the same time?

Thanks,
Kristy

Mark W. · Mar 7th, 2002, 12:55 PM

Right-click any worksheet tab and choose "Select All Sheets" from the popup menu. Make your column selection on the active worksheet and apply your formatting.

Von Pookie · Mar 7th, 2002, 01:02 PM

That was it. I couldn't remember it for the life of me, and it was driving me nuts!

Thankee much!

Mar 7th, 2002, 12:36 PM	#1
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	I have a workbook with 12 tabs (one for each month). Each sheet is exactly the same, except for the information that is entered, of course. I would like the change the font of A3:H80 for all the worksheets. Is there some way I can do this all at the same time? Thanks, Kristy __________________ Kristy How to post (Video) Show your sheet on the board (HTML Maker FAQ)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 12:55 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Right-click any worksheet tab and choose "Select All Sheets" from the popup menu. Make your column selection on the active worksheet and apply your formatting.

Mar 7th, 2002, 01:02 PM	#3
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	That was it. I couldn't remember it for the life of me, and it was driving me nuts! Thankee much!