fuzzygruf: (Jumper)
[personal profile] fuzzygruf
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.

Profile

fuzzygruf: (Default)
fuzzygruf

April 2017

S M T W T F S
      1
2345678
9 101112131415
16171819202122
23242526272829
30      

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Sep. 25th, 2017 02:36 am
Powered by Dreamwidth Studios