Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting the best from Excel when Changing Jobs/Offices

Tips and Tricks

Getting the best from Excel when Changing Jobs/Offices

by  gizmo1973  Posted    (Edited  )
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

Hope these help in some small way
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top