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?
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?