Tag Archives: excel 2010

Excel 2010: The Watch Window

Data changes result in recalculations of totals which are not always visible, depending on your spreadsheet layout. To keep an eye on how these totals are being affected without dashing around your spreadsheet, collect the important totals into a Watch Window. You can then see the collective effect of your new data from wherever you are in your file.

To add a cell or cells to this window, select the Formula tab, Watch Window, and click the Add Watch button. Select the cell or cells to be watched and click Add. Continue by adding others in the same way.

The Watch Window

Excel 2010: Saving In The Old 2003 Format

Whilst everyone is changing from the old 2003 version of Excel to the new 2010 version, some people will still need to provide spreadsheets in the older version. If this is for a single or occasional file, in the Save As dialog box simply change the File Type in the bottom box to Excel 97-2000 Workbook, beneath the File Name.

Save In Old StyleIf you are saving in the old format on a regular basis, it will be simpler to change the default file format. Click on the File tab and select Options, and on the Save page, change the default File Type at the top. When everyone is converted, change this back to Excel Workbook.

Default Saving screen

Excel 2010: AutoCorrect Options

AutoCorrect entries simply replace a text error or shortcut with the correct or longer version. For example, typing “teh” will automatically correct to “the”. This feature has a long list of entries which you may wish to change, remove or add to.

Select the File tab, Options and go to the Proofing tools page. Click on AutoCorrect Options to see the dialog box and list, and the Replace and With boxes to add your own. Whatever is typed in the Replace box in the future will be automatically changed to your With entry, unless you switch the feature off with the Replace Text As You Type check box half way down the page.

AutoCorect list If this feature is left switched on, certain Exceptions can be added to the rules with the button on the right, as these examples show.

AutoCorrect Exceptions

Excel 2010: Creating Custom Lists

There are many built in lists in Excel, numerical, date/time, text and numerical, and some text entries for month and day (try typing Jan in a cell and replicate the sequence down with the bottom right corner of the cell). For sequences that are not immediately available, Excel gives you the option of creating your own customised text lists.

Go to the File tab and select Options. On the Advanced page (tab at the left), scroll down to the General section where you see the Edit Custom Lists button. Click to open the dialog box.

Adding a custom listIf you have a list already in a spreadsheet, select the cells first. Now go to the Custom Lists dialog box and use the Import button to save retyping the entries.