How to exempt rows from being hidden/filtered in Excel 2010?
Posted
by
tarheel
on Super User
See other posts from Super User
or by tarheel
Published on 2012-10-11T15:28:07Z
Indexed on
2012/10/11
15:39 UTC
Read the original article
Hit count: 168
Consider a spreadsheet that starts looking like this:
I want to be able to filter for Name 1 on the left column and have it look like this:
Yes, I realize that the simple answer is to filter for Name 1 and Header, but I have other people using this spreadsheet that don't seem to get that. So, how can I make it foolproof for them and make it impossible to filter out the rows that have Header in the left column?
© Super User or respective owner