How to Keep the Selection View While Building a Formula in Excel
Question details
The user needs a way to prevent the worksheet from automatically scrolling back to the active formula cell after selecting a distant cell reference.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Building a formula that requires referencing multiple non-adjacent cells located far down or across the worksheet.
- Observed behavior
- After selecting a distant cell reference and typing a separator, the spreadsheet jumps back to the formula cell, causing the user to lose their place and forcing them to scroll repeatedly to select additional cells.
Consider zooming out your worksheet slightly to see more data at once, or use the Split View feature if you frequently need to reference top and bottom rows simultaneously.
Use the Ctrl Key for Multiple Cell Selection
Holding the Ctrl key automatically adds commas to your formula and allows you to select multiple distant cells without the screen jumping back to the active cell.
This built-in shortcut bypasses the need to manually type a comma after every cell selection, which is the action that usually triggers the spreadsheet to snap back to the formula cell.
Select the cell where you want the result to appear and type an equal sign followed by your desired function (e.g., type =SUM( to start a sum calculation).
Before clicking on any distant cells, press and hold the Ctrl key on your keyboard. For Mac users, hold the Command (Cmd) key instead.
While keeping the Ctrl key pressed, scroll to and click on all the required cells or drag to select ranges. The screen will stay on your current view, and cell references will be added automatically.
Once all necessary cells are selected, release the Ctrl key, type the closing parenthesis ), and press Enter to finalize your formula.

Master Complex Formulas Easily with WPS Spreadsheet
WPS Spreadsheet offers a smooth, intuitive interface for building complex formulas across massive datasets without frustrating screen jumps. It is completely free, lightweight, and fully compatible with all Microsoft Excel files.
- 1. Open your workbook in WPS: Launch WPS Spreadsheet and open your existing Excel (.xlsx) file.
- 2. Begin your calculation: Select the output cell and start typing your formula, such as =SUM(.
- 3. Select distant ranges smoothly: Scroll to the distant cells, hold the Ctrl key, and click the cells you need. WPS will seamlessly keep your view right where you are working.
- 4. Finish and apply: Type the closing parenthesis and press Enter. The calculation is instantly applied with zero hassle.

Frequently Asked Questions
Why does Excel jump back to the active cell when I type a comma?
By default, typing a comma while editing a formula tells the program you have finished the current argument. In many views, this triggers the spreadsheet to snap back to the active cell to show you the formula in its original context. Using the Ctrl key bypasses the need to type commas manually, preventing the jump.
Can I use the mouse wheel to scroll while holding Ctrl?
No, holding Ctrl while using the mouse scroll wheel will typically zoom in or out of the worksheet. Instead, scroll to the approximate area first, press Ctrl, click the cell, release Ctrl to scroll again, and press Ctrl before clicking the next cell.
Is there an alternative to manually selecting distant cells?
Yes! You can define 'Named Ranges' for your data. By highlighting a range and typing a name in the Name Box (top left), you can simply type that name into your formula (e.g., =SUM(Q3_Sales)) instead of scrolling to select the cells manually.




