Row

Home Search Site Map

Up
AutoFormat...
Cells...
Column
Conditional Formatting...
Row
Sheet
Style...

New! Excel User Group Now Open @ www.excelusergroup.org, Check It Out!


Menu command Type What happens next?
Row Followed by the sub menu below to format rows.

allows you to set the height of the selected row(s) in twips.

The dialog looks like this...(Excel's installed default height is 12.75, which is equal to 17 pixels).).

You can manually set the row height by hovering over the join between row labels. (The cursor will change to an North-South arrow), click and drag.

AutoFit will size the selected row(s) to the tallest entry in it.  This can be done without going through this menu option by simply highlighting the row(s) and hovering between any of the row labels, (you will get a North-South arrow cursor) and double-clicking.

Hide will hide selected row(s). This is useful if the row(s) do not need to be displayed but may have sub-calculations in them. Remember you can hide and unhide row(s) in 'View>Custom views'.

Unhide will unhide row(s) that have been previously hidden. You will either need to select the rows both sides of the hidden one(s) or use 'Edit>Go to...' and select an address in the hidden row(s) and then take this option.

VBA Sub FormatRows()
Dim myRange As Range
Set myRange = Range("A1")
'Set row height of Row(1) to 20 and hide row 2
With myRange
.EntireRow.RowHeight = 20
.Offset(1, 0).EntireRow.Hidden = True
End With
End Sub

Top

Copyright Nick Hodge 2008. All Rights Reserved.