When filtering in this sheet in column B I would like row 2,10,22,35 (blanks) to always be visible even though that (blanks) were not selected in filtering for column B. These rows are "headers" and I want them to never be excluded in the filtering. Can it be done?
excel.jpg
Probably not. You could put a "dummy" character, word or phrase on the rows that have subheadings. Format the font as the same colour as the cell fill colour and it won't show up. Maybe use the word "sub-head".
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I think you HAVE to select the blanks as well, to make that work
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks