Office Settings & Configuration

How to Prevent Excel from Opening Hyperlinks When Clicking Cells

Maira Mehtab Sep 21, 2026 871 views

Question details

The user needs a way to select or interact with Excel cells that contain active hyperlinks without triggering the links to open another application.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Selecting, editing, or moving multiple or nonadjacent cells containing hyperlinks without inadvertently launching a web browser or external application.
Observed behavior: Clicking anywhere on a hyperlinked cell automatically opens the hyperlink, because Excel treats the entire cell block as an interactive link rather than just the text itself.

Before you start

Before proceeding, determine if you are trying to select a single hyperlinked cell or multiple nonadjacent cells, as different workarounds apply based on the volume of cells you are managing.

Solution 1Recommended

Select Cells Using the Blank Space or Keyboard Navigation

This is the safest and most efficient workaround for selecting a hyperlinked cell without activating the link or needing advanced coding.

Because Excel treats the entire cell area as an interactive hyperlink, you must either find a safe zone to click or bypass the mouse entirely using your keyboard.

Click the Blank Space Inside the Cell

Hover your mouse cursor near the very edge of the cell, away from the blue hyperlink text. Wait until the cursor changes from a pointing hand icon to a thick white cross, then click to select the cell.

Navigate Using Keyboard Arrow Keys

Alternatively, click on a normal, non-hyperlinked cell adjacent to the one you want to select. Use the arrow keys on your keyboard to move the selection box onto the hyperlinked cell without triggering the link.

Selection Tip: Once the cell is selected using the keyboard, you can safely copy, paste, or format it without the link opening.

Solution 2

Use a Long Click to Enter Edit Mode

Clicking and holding the mouse button forces Excel to select the cell instead of instantly opening the hyperlink.

Solution 3

Redesign Layout or Use a Custom VBA Macro

If preserving the links while restricting click behavior is strictly required for a large workflow, advanced layout changes or macros are necessary.

Free Microsoft Office alternative

Edit Spreadsheets Efficiently with WPS Office

If you are frustrated with layout and formatting limitations in Microsoft Excel, try WPS Office. It provides a lightweight, highly compatible spreadsheet editor that makes managing complex links and large datasets easier, entirely for free.

1. Download and Install WPS Office: Visit the official WPS website, download the free suite, and follow the standard installation prompts.
2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing Excel workbook. All your hyperlinks and formatting will be perfectly preserved.

Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formats.Lightweight design ensures fast loading of large datasets with thousands of hyperlinks.Familiar user interface requires zero learning curve for existing Excel users.Advanced formatting tools to easily manage cell properties and bulk-edit text.

microsoft office alternative - wps office

Frequently Asked Questions

Can I make Excel only open the hyperlink when clicking the specific text?

No. By default, Excel treats the entire cell area as a single interactive element when a hyperlink is applied. You cannot natively restrict the clickable area to just the text without relying on custom VBA macros.

Does turning off AutoFormat remove my existing hyperlinks?

No. Disabling the 'Internet and network paths with hyperlinks' AutoFormat setting only prevents newly typed URLs from automatically converting into hyperlinks. It does not deactivate or remove any existing hyperlinks already present in your cells.

How can I select multiple nonadjacent hyperlinked cells efficiently?

Hold down the 'Ctrl' key and carefully click the extreme edges or blank spaces within each hyperlinked cell (ensure the cursor is a thick white cross, not a pointing hand). You can also select adjacent blank cells and use 'Ctrl + click' along with arrow keys to manage your selection.

Office App Problems