Log in

Excel: Custom View - fuzzygruf's blog

> Recent Entries
> Archive
> Friends
> Profile
> Homepage

LJ Update
LJ Recent Comments
Search LJ FAQs
Edit LJ userpics
Manage filters
LJ collage
Edit LJ links
LJ guests and statistics
upload to scrapbook
LJ Stats
LJ portal

August 29th, 2014

Previous Entry Share Next Entry
08:00 am, August 29th - Excel: Custom View
I import reports daily to Excel and apply the same filters every morning before sending it to the client.

Now I use Custom View to do this mindlessly. Once you've applied the filters you want to save (including print settings if you want), go to the View tab, then click on Custom Views in the Workbook Views section. ADD and name your view.

Next time, just go to View, Custom Views, and click SHOW.

(Leave a comment)

> Go to Top