Hiding rows but retaing the information

  • Thread starter Thread starter tox
  • Start date Start date
T

tox

The problem I have is, I have three rows, with row #3 three having filters
along about fifty columns.I wish to hide row #4 to #18 and keep rows #19 to
#60 unhidden.

However, when I hide #4 to #18, it appears to hide the information to the
filters. Is there a way to hide the rows, but not the information in the
filters?

Thanks in advance, group.

tox
 
tox,

I think the only way to do what you want is to set the row height to 1.
You'll get a grey band where rows 4 to 18 should be, but their information
will still be available to the filters.

HTH,
Bernie
MS Excel MVP
 
Bernie Deitrick said:
tox,

I think the only way to do what you want is to set the row height to 1.
You'll get a grey band where rows 4 to 18 should be, but their information
will still be available to the filters.
Click to expand...

Cheers Bernie, I thought I might have to do something along those lines.

Regards
tox
 
Back
Top