Function Problems

Enter the Same Formula in Multiple Excel Cells at Once

Nimra MalikNimra Malik Nov 18, 2026 869 views

Question details

Enter a formula into multiple Excel cells simultaneously.

Enter the Same Formula in Multiple Excel Cells at Once
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user wants to populate a selected cell range with a formula in one action.
Observed behavior
The formula is entered across the selected range, with relative references adjusted for each cell.
Before you start

Identify the destination range and check whether its cells contain data you want to keep; entering the formula will replace their contents. Write the formula for the active cell in the selection and use dollar signs for references that should stay fixed.

Solution 1Recommended

Select a range and enter the formula with Ctrl+Enter

Use Go To and a keyboard shortcut to fill the selected cells in one action.

1
Open Go To

In the Excel worksheet, press Ctrl+G to open the Go To dialog.

2
Select the destination

Enter a range such as B2:B10 in the Reference box, then press Enter.

3
Type the formula

With the range still selected, type a formula for the active cell, such as =A2*2 when B2 is active.

4
Fill the selection

Press Ctrl+Enter instead of Enter. Excel enters the formula throughout the selected range.

Select a range and enter the formula with Ctrl+Enter
Check cell references: Relative references adjust for each destination cell. Use an absolute reference such as $A$2 if a reference must remain fixed.
Work with formulas in WPS Spreadsheets

Enter a formula across multiple cells in WPS Spreadsheets

Open your workbook in WPS Spreadsheets, select the destination range, and use Ctrl+Enter to apply a formula to the selected cells.

  1. 1. Open the workbook: Open WPS Spreadsheets and use Open to select your workbook.
  2. 2. Select the cells: Drag across the destination cells, or press Ctrl+G and enter a range such as B2:B10.
  3. 3. Type the formula: With the range selected, type a formula for the active cell, such as =A2*2.
  4. 4. Apply the formula: Press Ctrl+Enter to enter the formula across the selected cells, then check the results.
Enter a formula across a selected range in one actionUse relative and absolute cell referencesOpen and save Microsoft Excel XLSX and XLS filesWork with a familiar spreadsheet interface
microsoft office alternative - wps office

Frequently Asked Questions

How do I select a range without dragging?

Press Ctrl+G in Excel, enter a range such as B2:B10 in the Reference box, and press Enter.

Why do the cell references change across the range?

Excel adjusts relative references based on each destination cell. To keep a reference fixed, add dollar signs, as in $A$2.

What happens if the selected cells already contain data?

Pressing Ctrl+Enter replaces the existing contents of the selected cells with the formula. Check the range before applying it.

Can I use the same method in WPS Spreadsheets?

Yes. Select the destination range, type the formula for the active cell, and press Ctrl+Enter to apply it across the selection.