Excel: Custom View
Aug. 29th, 2014 08:00 amI 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.
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.