Tips for Microsoft Excel

Draw borders, use functions and error-free printing

Draw borders with 'pen & pencil'

You can draw borders on any cell in a spreadsheet in the same way you can draw a table in Word.

See the contents of narrow columns

You're probably familiar with the hashes that appear if a number is too large for the width of a column. To see the numbers just make the column wider.

In Excel 2003 you can see the value in a cell by hovering your mouse over the hashes.

Coloured sheet tabs

Keep your workbooks organised by colour-coding the worksheet tabs. Just right-click on a worksheet tab and choose from the colours available.

Keep an eye on important cells

Keeping track of what happens to key cells when you change values in other cells is easy. You can add a Watch to any cells so you can always see their value in a special Watch Window.

	��Get the latest advice with our free newsletters.

Finding the right function

There are so many functions available, that it using the right one could be difficult. In Excel 2003 you can search for a function using ordinary English:

Suppressing cell errors when printing

Don’t panic if your spreadsheet contains a cell error such as #NAME? or #REF and you need to print it out.

What next?