3 EASY things in Excel

These things will save you oodles of time when working with Excel.

One – Auto Fill

Use Autofill to fill a list in Excel. This is a fab shortcut when you want to create a series such as a number series or perhaps a date series.

Type the first number in your sequence

Place the cursor on the bottom right hand corner of the cell

Hold down your left mouse button and drag the cursor down the column or across the rows.

Excel will either – copy the value you typed in and offer you a smart tag button on the sheet, which will give you some options, or it will create a series directly.


Two – Add things up without creating a formula

When you need to add up a selection of your data you can use the status bar at the bottom of the screen to see what the total is.

Highlight the cells you wish to add up

Look at the status bar and you will see the result


Three – Format Painter

Use the Format Painter to copy a format from one place to another

Select the cell with the formatting you wish to copy

Click once on the Format Painter Icon

Click on the cell you wish to apply the formatting to.

To apply the formatting in more than one place simply double click on the format painter icon and then you can apply the formatting in lots of places. When you are finished, click the icon again to switch it of.

I hope you found these tips useful.