Hints and tips home » Excel hints and tips » Fill formulae across a sheet

Fill formulae across a sheet

To copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. Unfortunately, no similar facility exists to copy formulae across the sheet.

One reasonably quick way to copy an existing formula across a sheet is to select the formula and the cells on the right to which you want to copy it. Then press Ctrl+R to copy the formula across the selected range, or, if you are menu-minded, use the Edit|Fill|Right command.

Added by Alan on 16th September 2006

More Excel hints and tips, like:

• Do a fast scroll
• Selecting blank cells within a range of data
• Quickly insert a function