'%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 Disable Ctrl+Click for Excel Hyperlinks in OneDrive
Question details
Users want to disable the Ctrl+Click requirement for opening hyperlinks in Excel for the web to restore single-click functionality.
- Product
- Excel for the web (OneDrive)
- Device & OS
- not provided
- Scenario
- Navigating spreadsheets with multiple hyperlinks in a web browser, especially for users relying on single-click accessibility.
- Observed behavior
- Excel for the web currently mandates holding Ctrl while clicking a hyperlink to open it, with no built-in setting to revert to a single-click action.
Since Excel for the web operates differently from the desktop version, ensure your browser is updated and verify if you have access to the desktop version of Excel for alternate workflows.
Open the Spreadsheet in the Excel Desktop Application
Since Excel for the web restricts modifying hyperlink behaviors, switching to the desktop app allows you to customize link clicking and restore single-click functionality.
Excel for the web hardcodes the Ctrl+Click behavior to prevent users from accidentally navigating away from the page while editing cells. Fortunately, the desktop application retains full control over this setting.
Locate the 'Viewing' or 'Editing' button on the top ribbon of Excel for the web, then select 'Open in Desktop App' from the dropdown menu to launch your spreadsheet locally.
Once the file opens in the desktop application, click on 'File' in the top-left corner and select 'Options' at the bottom of the menu.
Navigate to the 'Advanced' tab on the left sidebar. Under the 'Editing options' section, uncheck the box labeled 'Use CTRL + Click to follow hyperlink', then click 'OK' to save your changes.
Submit Feature Request to Microsoft
Request an accessibility setting or toggle for single-click hyperlinks directly from the web interface so Microsoft can prioritize a fix.
Experience customizable spreadsheet navigation with WPS Office
If Excel for the web's forced hyperlink behavior slows down your workflow, consider switching to WPS Office. It provides a lightweight, highly compatible desktop experience where you retain full control over editing behaviors, including single-click hyperlink settings, without the frustrating browser limitations.
- 1. Download WPS Office: Install the free WPS Office suite on your desktop device.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing .xlsx files directly.
- 3. Customize Options: Go to Menu > Options > Edit to easily manage your preferred hyperlink navigation styles.
Frequently Asked Questions
Why did Excel for the web change to require Ctrl+Click for hyperlinks?
Microsoft implemented this behavior in the web version to prevent users from accidentally clicking links and navigating away from the page while trying to select or edit the contents of a specific cell.
Can I disable Ctrl+Click for hyperlinks in the desktop version of Excel?
Yes. In the Excel desktop application, you can navigate to File > Options > Advanced, and uncheck the 'Use CTRL + Click to follow hyperlink' option to completely restore single-click functionality.
Is there a browser extension to bypass the Ctrl+Click requirement in Excel for the web?
Currently, there are no reliable browser extensions that can override Excel for the web's native hyperlink behavior, as the requirement is built directly into the web application's core scripts.
