'%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)
Why Excel for the Web Requires Ctrl+Click for Hyperlinks
Question details
Users want to know why clicking a hyperlink in Excel for the web displays a command box instead of opening the link, and how to properly interact with hyperlinks.
- Product
- Excel for the web
- Device & OS
- not provided
- Scenario
- Clicking or hovering over a hyperlink in an online Excel spreadsheet.
- Observed behavior
- Excel for the web displays a hyperlink command box rather than immediately navigating to the linked destination, requiring the user to use a Ctrl+Click shortcut.
Ensure you have a stable internet connection and are logged into your Microsoft 365 account to access your online workbooks.
Use Ctrl+Click or the Hyperlink Command Box
Navigate and manage your hyperlinks using the updated Excel for the web interface designed for safer link editing.
Microsoft updated Excel for the web to display a command box when you interact with hyperlinks. This behavior is intended to make link editing and cell selection safer by preventing accidental redirects to unintended or malicious websites.
Open your workbook in Excel for the web and place your mouse pointer over the cell containing the hyperlink.
Notice the small command box that appears, which includes options such as 'Go to destination', 'Copy link', 'Edit link', and 'Delete link'.
To bypass the menu and open the hyperlink directly, press and hold the 'Ctrl' key on your keyboard, then click the hyperlink.
Try WPS Office for a Seamless Spreadsheet Experience
If you find the recent web-based UI changes in Microsoft Excel disruptive to your workflow, consider switching to WPS Office. It offers a powerful, lightweight desktop suite that handles hyperlinks and spreadsheet editing intuitively.
- 1. Download WPS Office: Visit the official WPS Office website and download the free desktop application.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx or .xls files seamlessly.
- 3. Manage Hyperlinks Easily: Click hyperlinks directly or right-click to edit them without mandatory keyboard shortcuts like Ctrl+Click.
Frequently Asked Questions
Can I disable the Ctrl+Click requirement for hyperlinks in Excel for the web?
Currently, Excel for the web does not have a built-in toggle to disable the Ctrl+Click behavior. This feature was permanently implemented to improve security and make cell selection easier. You can submit feedback to Microsoft if you wish to see a toggle option in the future.
Why did Microsoft change how hyperlinks work in Excel online?
The change aims to make link editing and cell selection safer. By requiring a Ctrl+Click or displaying a command box, it prevents users from accidentally opening unwanted links when simply trying to select the cell for editing.
What options are available in the new hyperlink command box?
When you hover over or click a cell with a hyperlink, the command box provides quick-access buttons to 'Go to destination' (open the link), 'Copy link', 'Edit link', and 'Delete link'.
