Enter the Same Formula in Multiple Excel Cells at Once
Question details
Enter a formula into multiple Excel cells simultaneously.

- 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.
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.
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.
In the Excel worksheet, press Ctrl+G to open the Go To dialog.
Enter a range such as B2:B10 in the Reference box, then press Enter.
With the range still selected, type a formula for the active cell, such as =A2*2 when B2 is active.
Press Ctrl+Enter instead of Enter. Excel enters the formula throughout the selected range.

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. Open the workbook: Open WPS Spreadsheets and use Open to select your workbook.
- 2. Select the cells: Drag across the destination cells, or press Ctrl+G and enter a range such as B2:B10.
- 3. Type the formula: With the range selected, type a formula for the active cell, such as =A2*2.
- 4. Apply the formula: Press Ctrl+Enter to enter the formula across the selected cells, then check the results.

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.




