'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Follow Formula References in Excel for the Web (Shortcuts)
Question details
The user wants to find the keyboard shortcut in Excel for the web to select a formula cell and navigate to its referenced cells, similar to the desktop version.
- Product
- Excel for the web
- Device & OS
- not provided
- Scenario
- Tracing formula precedents or navigating to referenced cells while editing or reviewing formulas in a web browser.
- Observed behavior
- The user needs to achieve the same result as pressing Ctrl+[ in desktop Excel to instantly jump to a referenced cell in the online version.
Ensure you have edit permissions for the spreadsheet and that your browser is not intercepting or overriding the keyboard shortcuts you intend to use.
Use the Default Keyboard Shortcut to Trace Precedents
The quickest way to jump to referenced cells in a formula on Excel for the web is by using the built-in keyboard shortcut.
Excel for the web supports many of the same keyboard shortcuts as the desktop version. The shortcut to trace formula precedents directly moves your active cell selection to the referenced data.
Click on the cell containing the formula that references other cells within your workbook.
Press the Ctrl + [ (Control and the left bracket) keys simultaneously on your keyboard. Excel for the web will highlight and instantly move your selection to the referenced cell or range.
Trace Formula References Easily in WPS Spreadsheet
If browser shortcuts are causing conflicts, WPS Office provides a robust, lightweight desktop application where formula auditing and shortcut keys work flawlessly.
- 1. Open your Workbook in WPS Office: Launch WPS Spreadsheet and open your .xlsx file.
- 2. Select the Formula: Click on the cell containing the formula you want to inspect.
- 3. Trace Precedents: Go to the 'Formulas' tab in the top ribbon and click on 'Trace Precedents' to draw visible arrows to the referenced cells.
- 4. Use the Shortcut Key: Alternatively, press Ctrl + [ on your keyboard to immediately jump to the referenced cell without browser interruptions.
Frequently Asked Questions
Why isn't Ctrl + [ working in my web browser?
Some web browsers or browser extensions map Ctrl + [ to their own default shortcuts, such as navigating back to a previous page. If this happens, try using Excel for the web in an incognito/private window, or switch to a desktop application like WPS Office.
How do I return to the original formula cell after tracing?
After jumping to a referenced cell using Ctrl + [, you can quickly return to the original formula cell by pressing F5 followed by Enter, or by using Ctrl + G to open the Go To dialog which remembers your previous cell.
Can I trace dependent cells in Excel for the web?
Yes. To find cells that depend on the currently selected cell (trace dependents), you can use the keyboard shortcut Ctrl + ] (Control and the right bracket key).
