Click on the rectangle above the row numbers and left of the column letters
to select the entire sheet. Then you can use Format from the menubar to
format cells or rows. James
If you want to change the default font size, or any cell formats, for ALL
sheets it would be better to change the Normal style of the workbook.
Format, Style...
or with code say
ActiveWorkbook.Styles("Normal").Font.Size = 12
Row heights in all sheets will adjust automatically to the new Normal style
font attributes. Also clear-formats if used will reset the workbook's Normal
style in cells.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
