View Single Post
 
Old 12-07-2022, 03:07 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

On the View ribbon there is a button called Custom Views. You can use this to store and retrieve your different views.

Start with adding a Show All view. Then customise your workbook view and add each one as a new view.

When you save a custom view you can choose to include print settings, hidden rows/columns and filter settings.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote