Having been made redundant twice last year I have moved around somewhat.
Whenever I arrive at a new workplace the 1st thing I do is set up my MS excel, these tips may well save you some time as they have saved me plenty.
Create a custom toolbar.
Tools, Customize, New, (name your toolbar), Then drag over the most useful icons (to you) I find the following most useful but you may want to experiment
AutoFilter, Delete Rows/Columns, Paste Values/Formats, Merge Cells, Save As, E-Mail as attachment and so on.
You could also add Icons to any of the existing bars but I use that many that a custom bar suits me best.
I would then save this workbook somewhere to hand to enable your changes to save; you can then also in future save any Macros that you may need to run in many different books here as well and then open this book each time or even auto-run on start
AutoSave add-in
Another invaluable lifesaver.
If never used before this Add Inn needs to be switched on.
Tools, Add Inns, Tick box for AutoSave add-in
Then Tools Auto save and select your criteria, I always use Automatic save every 5 minutes on all active workbooks with a prompt before saving.
This has saved my job so many times but few people use it or even realize it exists
Other Add-Ins
There are many different add-ins to pick from and too many to go through here so have a look and them and experiment you may find an answer is sat there waiting to be found if not you can ALWAYS ask on Tek-Tips
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.