Tag Archives: formatting

Conditional Formatting: highlight items automatically

Posted on 25 August 2013 by spreadsheetexpertblog

Conditional Formatting changes the font, border or colour of a cell depending on the criteria you have chosen. For example you might set a cell to go red if it went over 32 or green if a certain date is … Continue reading →

Posted in Uncategorized | Tagged , | Leave a comment

Don’t be sloppy when entering information

Posted on 5 August 2013 by spreadsheetexpertblog

Well-structured information is the key to making the most of Excel. Each different data type should appear in its own column. Generally, it’s best to think of each row as a record (client names, sales records, inventory items, etc), with … Continue reading →

Posted in Uncategorized | Tagged , | Leave a comment

Date formats – don’t waste valuable information!

Posted on 28 July 2013 by spreadsheetexpertblog

Don’t enter dates with full stops (eg 10.11.13) because Excel doesn’t store them as dates, meaning a lot of useful information is unavailable. Instead, use a slash (eg 10/11/13) or hyphen (10-11-13) when you enter dates. Excel then stores them … Continue reading →

Posted in Uncategorized | Tagged , , | Leave a comment

Adjusting column width in Excel

Posted on 28 July 2013 by spreadsheetexpertblog

The column width can be adjusted by going to the top of the column and dragging the cursor left or right. This manual method means you’re only judging by the few rows you can see on the screen. However, double-clicking … Continue reading →

Posted in Uncategorized | Tagged , | Leave a comment