iSumsoft » Resources » Office » 3 Way to Apply Formula to Rows or Columns in Excel

How to Apply Formula to Entire Columns or Rows in Excel

Roy Ulerio
Roy Ulerio

Updated:

This is a tutorial on how to quickly apply formula to entire rows or columns in Excel.

This guide describes how to auto-fill formulas into adjacent cells by using the fill handle and fill command on Excel Ribbon. It hidden tricks will help you auto-fill cells with data that follows a pattern in a worksheet. There are several ways to copy formula into neighboring cells in any direction, here's how:


Option 1: Drag the fill handle to copy the formula

In Excel, select the cell that contains the formula you want to copy. Click, hold and drag the fill handle to copy the formula to adjacent cells.

Drag fill handle to apply formula

Option 2: Double-click fill handle to copy formula

Double-click on the bottom-right corner of the cell Fill handle that contains the formula you want to apply formula to entire column.

Apply formula to entire column

Option 3: Copy formula using Fill command.

To apply the formula to entire column, here's how:

Step 1: Enter the formula into the first cell of that column, press Enter.

Step 2: Select the entire column, and then go to Home tab, click Fill > Down.

Copy formula using Fill command

To apply formula to entire row: Click Home > Fill > Right.

Or

Ctrl+R: Continue applying formula into neighboring cells in right direction.

Ctrl+D: Continue applying formula into neighboring cells in down direction.