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.
 

Ask a Question

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.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Repeating a row other than the 1st row as the header row in a table from next page 1
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Insert Index into a Table 1
Changing row background from external program 0
Copy addition formula of non-consecutive horizontal cells 2
Code to cut a paragraph that's followed by a table 2
Word VBA - Automatic change content of a cell in table using dropdown list 5

Top