Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Microsoft: Office FAQ

Tips and Tricks

Getting the best from Excel when Changing Jobs/Offices by gizmo1973
Posted: 13 Aug 04

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

Back to Microsoft: Office FAQ Index
Back to Microsoft: Office Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close