How to exempt rows from being hidden/filtered in Excel 2010?
- by tarheel
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?