Format
Entering mobile numbers
Excel has problems with leading zeroes. If you enter a mobile phone number in a cell Excel is likely to remove the leading zero. There are couple of ways to handle this.
Finding formats
Excel 2007 has a new feature that allows you to find formats. To find a cell(s) with a certain format you use the normal Find system which has had format functionality added to it.
Cell styles (Excel 2007)
The Cell Styles button, located on the Home ribbon tab in the Styles section, offers you an easy way to standardise your Excel formatting.
Selecting cells (Excel 2007)
Excel 2007 has simplified the selection of certain types of cells. Previously you needed to go through the Go to dialog and the Special button. Now the options are available on the Home ribbon tab.
Fraction format
Ever needed to display a fraction in a cell and have it used in calculations? Well you can achieve that fairly easily by entering a zero and a space before entering the fraction.
Colour code sheet tabs
Colour is a powerful communicator. Effective use of colour in your spreadsheets can make them easier to use and understand.
Wrapping text
The Wrap Text format is often used to reduce the width of a column and still allow the contents to be displayed, as it creates line breaks within a cell.
Merge and centre warning
Ever had an error message which stated that you couldnt do something to a merged cell? Well the merge format is the culprit.
Custom colours
Ever wanted to use colours in your spreadsheet that match your company's corporate colours?
Format painter
One of the more useful toolbar icons is the 'format painter'.
