Custom Views + hidden columns does seem to work

B

BLUV

Hi there,

I was hoping you could help with some custom views. I've figured out how to
create custom views just fine and have created 6 of them. What I wanted to
do next was create an identifier on the spreadsheet that would tell the user
which view is currently being used (for both viewing and printing).

I tried adding 6 rows at the top of the spreadsheet with the name of each
view in one row. I would then hide 5 rows and keep row with the view I want
identified visable. Then I would save the view. This works fine if I am
only hidding and unhidding rows and columns.

However....

I am also using autofilter, to only display specific items within each
column and have noticed that once I use the filter, all of my hidden rows
identifing the view are ingored when the view is saved.

Any ideas on how I can use filters, and hide rows in the same view? Or any
ideas on how I can make the current view the user has selected, visable for
printing and viewing?
 

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

Top