Hiding rows that are not grouped

M

michele

Hi,

I want to hide or unhide all the rows with n/a in column F. Does
anyone know of an easy way to do that?

Thanks,

Michele
 
B

Bob Umlas

Select col F. if the N/A is in without formulas, use Edit/Goto Special,
click Constants, then leave only the "errors" checked. Then click OK - now
only they will be selected. You can use ctrl/9 to hide them all (or
Format/Row/Hide)
Bob Umlas
Excel MVP
 
M

michele

Thanks Bob, but it gave me no cells were found. Your idea sounds
great, but I must be doing something wrong. I have Excel 2003 and the
n/a is just typed in and in general format in a centered column.
Here's what I did.

I clicked on the F to highlight column F. I choose Edit>Go To and saw
only one entry called Print_Titles and Reference was blank. I clicked
Special, then Constants. I unchecked Numbers, Text, and Logicals to
leave only Errors checked. (It's weird though because these four items
are under Formulas, not Constants, but clicking Formulas instead of
Constants didn't help.)

What am I doing wrong? I even tried it in a test sheet with no other
fancy stuff. This is a feature I haven't tried to use before and I
would like to learn it. I've read my Excel 2003 Bible, but it really
doesn't explain what is meant by error.

Thanks,

Michele
 
Top