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.
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.