hidden rows reappearing when using filter

B

Betty

Hi,

I have hidden some rows in a document which also has filters when I use the
filters to get to a particular data and then go back to viewing 'All' data
the hidden rows become unhidden, how can I stop this from happening?, any
suggestions?
 
R

Rachel7

Hi Betty,

I've found this to be a problem in the past. My work around was to either
remove the entry that you've hidden, or, to pivot the data rather than filter
it. That way you can 'de-select' the entry you don't want in the pivot table.
 
S

Shane Devenshire

Hi,

FYI - in 2007 this is no longer a problem because you can check and uncheck
any filtered items you want.

In 2003 I think the Pivot Table solution is a nice one.
 

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

hidden rows reappearing when using filter 0
hiding/unhiding rows 1
Stop rows that i have hidden unhidding when i filter in excel 0
Outlook meeting location auto prompts with a suggestion list - need to disable 0
Office Word JPEG in a document showing but not printing out 0
SUMIFS including hidden rows 1
Hidden rows columns won't stay hidden 0
Print (physical or pdf) not respecting format of source document 0

Top