Using Excel

Excel spreadsheet graphics

I love creating and using Excel spreadsheets.  They’re handy for business and personal use – and they give you a chance to be creative. Here are some of the most useful features for everyday use.

Autosum
If you only use one formula, this is the most helpful. It will add up figures in consecutive cells.

Option 1:
Place your curser in the cell that you want the total to go in.
Click:   Autosum up the top (top right-hand corner of Home tab).
Excel will guess what figures you want added. Use SHIFT + ARROW KEYS to change the cells from those that Excel has selected if necessary.
Hit ENTER|

Option 2:
Highlight the cells you want added up.
Click:   Autosum
Excel will place the total in the last cell you have highlighted.
Hit ENTER

Merge and Centre
Especially handy for headings that you want centered over a table.
Highlight the cells you want merged.
Click:   MERGE & CENTRE button up the top.
Type in your heading.

Fill handle
This will copy a formula along in consecutive cells, and save you having to re-type formulas in every cell.  Type the formula in the first cell you need it. Hover over the corner of the cell until you see the fill handle symbol +. Click and drag across the cells you want the formula in.

Troubleshooting:
###
If you see this in a cell it means that your column isn’t wide enough. Go up to the alphabet row and hover over the line to the right of the relevant column letter. Double-click to widen to the exact width needed to fit your data in.

What are your favourite Excel features?

Advertisements

6 comments

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s