'%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)
Fix Hyperlinks Not Opening When Clicking Cells in Excel for the Web
Question details
Users are unable to open inserted hyperlinks by left-clicking or hovering over cells in the web version of Excel.
- Product
- Excel for the web
- Device & OS
- not provided
- Scenario
- Clicking or hovering over a hyperlink created with Ctrl+K in a web-based Excel workbook.
- Observed behavior
- The hyperlink hover action fails and the link does not open on a standard left-click, though it functions correctly through the Edit Link interface or the right-click menu.
Ensure your web browser is updated to the latest version and verify that your internet connection is stable to rule out basic loading errors in Excel for the Web.
Adjust the Column Width (Recommended Workaround)
Due to a known bug in Excel for the web, reducing the column width to be shorter than the hyperlink text can restore the hover and click functionality.
Community discussions have highlighted that the hover action for hyperlinks in Excel for the web often breaks when the column is wider than the link text itself. Making the column narrower forces the interface to recognize the interactive link.
Find the column containing the hyperlinks that are not responding to clicks.
Hover your mouse over the right boundary of the column header, click, and drag it to the left to reduce the width.
Make sure the column's physical width is shorter than the length of the hyperlink text displayed in the cell.
Hover over the hyperlinked cell again to see if the clickable hand cursor appears, then left-click to open it.
Open Links Using the Right-Click Menu
If you cannot change the spreadsheet formatting or column widths, you can bypass the left-click bug using the context menu.
Clear Browser Cache and Switch Browsers
Clearing stored data or changing your web browser can resolve underlying script conflicts preventing Excel web features from working.
Edit Spreadsheets Seamlessly with WPS Office
Tired of encountering browser-based bugs in Excel for the web? Switch to WPS Office, a powerful and fully free desktop suite. It offers robust performance, flawless hyperlink functionality, and zero browser limitations, ensuring your workflow remains uninterrupted.
- 1. Download the software: Visit the official WPS Office website and download the free desktop application for your operating system.
- 2. Open your Excel files: Launch WPS Spreadsheet and open your existing .xlsx workbooks directly—no conversion needed.
- 3. Click links flawlessly: Hover and left-click on any hyperlink in your document. WPS Office processes local and web links instantly.
Frequently Asked Questions
Why do my Excel hyperlinks appear as plain text instead of clickable links?
This usually happens if the cell format was set to 'Text' before you typed the URL, or if auto-formatting is disabled. To fix this, double-click the cell and press Enter, or press Ctrl+K to manually assign the hyperlink format.
How can I edit a hyperlink in Excel without accidentally opening it?
To safely select a hyperlinked cell without triggering the link in a desktop environment, click and hold the mouse button on the cell for a few seconds until the cursor changes shape. Alternatively, use your keyboard's arrow keys to navigate to the cell, then edit the contents in the formula bar above.
Are there character limits to hyperlinks in Excel?
Yes, Microsoft Excel typically limits the length of a hyperlink path or URL to 255 characters. If your URL exceeds this limit, the link will fail to trigger. To bypass this, consider using a URL shortener or applying the HYPERLINK function formula instead of a standard embedded link.
