word wrapping the entire column on every sheet in the book?

[Rightmer]

I would also Like to have word-wrap on every cell in column B, on every sheet. Can I do this in one or two simple steps, rather than going to each sheet, and using the FORMAT CELLS option?

 

[Frank Kabel]

Hi
try the following:
1. Group the sheets clicking on the sheetname while holding down the
SHIFT key)
2. select column B
3. Apply your format
4. ungoup the sheets

 

[DDM]

Rightmer, quick and dirty: Right-click any worksheet tab in your workbook
and select Select All Sheets from the menu. Format Column B to taste.
Right-click a worksheet tab and select Ungroup Sheets. That will do all the
worksheets.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com

I would also Like to have word-wrap on every cell in column B, on every

sheet. Can I do this in one or two simple steps, rather than going to each
sheet, and using the FORMAT CELLS option?