Q. I want to show 3 different types of filtering on the same worksheet, depending upon who’s using it. Can I do that?
A. The technique you’ll use is Custom Views. With everything unfiltered, on the Views tab in the first group, Workbook Views, click the Custom Views button. Click the Add button to define this “all shown” view. This way you can always get back to it.
Now, filter rows and hide columns for the first view and repeat the process to define the views that you need. You’ll notice that you can also save multiple print settings this way, too!
Like what you've read? ...Republish it and share great business tips!
Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...
We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.
The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.
" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/36255/excel-custom-views "