Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Font size and rows height for whole sheet
Hi. How can I set the font size and rows height for entire sheet?
Greetings |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Font size and rows height for whole sheet
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 "bobens_83" wrote in message ... Hi. How can I set the font size and rows height for entire sheet? Greetings |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Font size and rows height for whole sheet
oh, if you were asking about VBA, like this:
Cells.Font.Size = 15 Rows.EntireRow.RowHeight = 20 "Zone" wrote in message ... 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 "bobens_83" wrote in message ... Hi. How can I set the font size and rows height for entire sheet? Greetings |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Font size and rows height for whole sheet
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. Regards, Peter T "bobens_83" wrote in message ... Hi. How can I set the font size and rows height for entire sheet? Greetings |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet Name Font Size | Excel Worksheet Functions | |||
How do I change the font size inside a sheet tab? | Excel Worksheet Functions | |||
how to change font size of datalabels of two charts in a sheet | Charts and Charting in Excel | |||
How can I change the font size on an Excel sheet tab? | Excel Discussion (Misc queries) | |||
Change font size on sheet tabs | Excel Discussion (Misc queries) |