Home > Support > Hints and Tips > Tip of the Week

Weekly Computer Tip # 40
15 November 2003

Start each week with a free tip

To subscribe, please type your email address in the box below:

Quickly repeating a formula down a column (Microsoft Excel)

You've probably used Excel's fill handle (the small black square in the lower-right corner of a cell) to copy formulas into adjacent cells, by dragging the fill handle over the empty cells that you want to autofill. However,

Did you know ...

You can use the fill handle to automatically enter the formula in the whole column as long as cells in the adjacent column contain data.

Here's how:

  1. Enter the formula as normal
  2. Point to the fill handle (the small black square in the lower-right corner of the cell) containing the formula and double-click it.

Excel will automatically copy, paste, and calculate the formula (including any formatting) down the column and will stop at the first blank cell.

Until next week. (In the meantime, why not have a look at this month's

Email this page to a friend

Enter recipient's email address in the box below:

PS I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.

Home   Training   Support   Clients   Contact Details   News   Disclaimer  

© Roem Ltd. All Rights Reserved
November 2003