Try creating a Custom View in Excel if repeated filtering and hiding columns and rows become drudgery.
Hide rows and columns either with right-click hide or by filtering. Then, in the View tab, Workbook Views group (first one on the left), choose the Custom Views button. Click Add to name your Custom View. The next time you need it, click on the View tab and the Custom View button. You'll see your Custom View in the list. Select the View and then the Show button. You can also save multiple print settings for the same worksheet.
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/31442/try-creating-a-custom-view "