Function Problems

How to Keep the Selection View While Building a Formula in Excel

Huma Ashraf ChHuma Ashraf Ch Nov 3, 2026 870 views

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.

How to Keep the Selection View While Building a Formula in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Start your formula

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).

2
Hold the Ctrl key

Before clicking on any distant cells, press and hold the Ctrl key on your keyboard. For Mac users, hold the Command (Cmd) key instead.

3
Select the distant cells

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.

4
Complete the calculation

Once all necessary cells are selected, release the Ctrl key, type the closing parenthesis ), and press Enter to finalize your formula.

Use the Ctrl Key for Multiple Cell Selection
Navigation Tip: If you want to quickly jump back to view the cell where you are actively typing the formula, simply press Ctrl + Backspace.
Seamless Spreadsheet Calculations

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. 1. Open your workbook in WPS: Launch WPS Spreadsheet and open your existing Excel (.xlsx) file.
  2. 2. Begin your calculation: Select the output cell and start typing your formula, such as =SUM(.
  3. 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. 4. Finish and apply: Type the closing parenthesis and press Enter. The calculation is instantly applied with zero hassle.
Smooth scrolling and intuitive cell selection for building long formulas.Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Free and lightweight alternative with a familiar user interface.Built-in advanced function library for heavy data analysis without lag.
microsoft office alternative - wps office

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.