Hiding a row?

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

If there is a "*" in a certain cell, how would you hide
that entire row. "*" will always be in column A but
different row numbers.
Thanks in advance
 
You can use a custom AutoFilter --

Select a cell in the table
Choose Data>Filter>AutoFilter
From the dropdown list in the Column A heading, choose (Custom...)
From the first dropdown, choose 'does not equal'
In the text box, type: ~*
(The ~ character is a tilde, and may be to the left
of the number 1 key on your keyboard)
Click OK

Any rows where there's an asterisk in column A will be hidden
 
Back
Top