Three Timesaving Microsoft Excel Tips

Here are three tips for MS Excel Users.

Tip One: Use the Color Code Feature For Your Excel Sheet Tabs - Version 2002 and above.

If you have multiple offices or departments, this is a nifty tip. You can color-code sheet tabs for easier identification or grouping of related sheets. Here's how:

  • Select the sheets you want to color by holding down the CTRL key and clicking the tabs.

  • On the Format menu, point to Sheet, and then click Tab Color.

  • Click the color you want, and click OK.

Tip Two: Automatically Save Your Spreadsheet Files

If you have ever regretted not saving a file, which we all have, here is a way to automatically save your spreadsheets so you don't lose your work?

In MS Excel 2000 there is a feature that allows you to save workbooks automatically at specified intervals.

Here's how you can install and use the Autosave Add-in:

First you need to load the add-in, which will add it to your Tools menu. Here's how:

  • On the Tools menu, click Add-Ins.

In the Add-Ins available list, select the Autosave Add-in check box and then click OK. If the Autosave Add-in is not available, you may need to install it. For more instructions, search for the phrase "Install or remove individual features of Microsoft Office or Excel" in Excel 2000 Help.)

To configure and use the Autosave feature do the following:

  • On the Tools menu, click AutoSave.
  • Select the Automatic save every check box.
  • In the Minutes box, enter how often you want Excel to save your workbooks.
  • Select any other options you want, and press OK.

Tip Three: Move From One Workbook or Worksheet Quickly!

When you are working with several workbooks or worksheets at once, you can easily move between them using the following shortcut keys.

  1. To move between open workbooks, press CTRL+TAB.
  2. To move to the next sheet in a workbook, press CTRL+PAGE DOWN.
  3. To move to the previous sheet in a workbook, press CTRL+PAGE UP.

Editors Note: If you have any tips or time saving software ideas, please send them into Editor

You may like these other stories...

Cybersecurity is no longer the domain of an organization's IT staff. It's moved to the boardroom, and in a big way. Accountants and financial managers may have been thinking it's just the province of the tech...
You probably don't want to think about how many times you access the File menu in Excel 2010 or 2013. Personally I think Excel 2010 has the best possible File menu arrangement, other than having Print Preview grafted...
Following other recent high-profile hacking events, investigators discovered yesterday that hackers broke into the draft work paper files of several famous CPA firms. Revealing images of the scantily clad documents have been...

Already a member? log in here.

Upcoming CPE Webinars

Sep 24
In this jam-packed presentation Excel expert David Ringstrom, CPA will give you a crash-course in creating spreadsheet-based dashboards. A dashboard condenses large amounts of data into a compact space, yet enables the end user to easily drill down into details when warranted.
Sep 30
This webcast will include discussions of important issues in SSARS No. 19 and the current status of proposed changes by the Accounting and Review Services Committee in these statements.
Oct 21
Kristen Rampe will share how to speak and write more effectively by understanding your own and your audience's communication style.
Oct 23
Amber Setter will show the value of leadership assessments as tools for individual and organizational leadership development initiatives.