How do I hide rows or cells in a table?

G

Greg

Format the entire row as hidden text and don't display hidden text in
Tools>Options>View

Sub Test()
Selection.Tables(1).Rows(?).Range.Font.Hidden = True
End Sub

Replace "?" in the code above with the row number you want to hide.
 
S

Stefan Blom

Or from the user interface: Select the row [or select the cell(s)]. On
the Format menu, click Font. Click the Font tab. Click "Hidden" to
select it, and then click OK.
 
Top