Office Settings & Configuration

How to Require Ctrl+Click to Follow Hyperlinks in Excel

Maira Mehtab Sep 20, 2026 868 views

Question details

The user wants to configure Excel to require pressing the Ctrl key while clicking a hyperlink to open it, preventing accidental link openings when trying to select a cell.

Product: Excel 2021
Device & OS: not provided
Scenario: Trying to select a cell containing a hyperlink to edit or format it, without accidentally triggering and opening the link in a web browser.
Observed behavior: Excel opens hyperlinks directly with a single left click and lacks the standard 'Ctrl+Click to follow link' option found in Microsoft Word.

Before you start

Before attempting to change hyperlink settings, note that Excel's default behavior differs from Microsoft Word. By design, Excel does not include a native toggle to require Ctrl+Click for opening links.

Solution 1Recommended

Use the Long Click Method to Select Hyperlink Cells

Since Excel does not have a built-in feature to require Ctrl+click for hyperlinks, you can use a click-and-hold technique to select the cell safely without activating the link.

Unlike Microsoft Word, Excel desktop versions do not include an option to toggle 'Use CTRL + Click to follow hyperlink'. Because links open immediately upon clicking, users often accidentally open websites when they simply want to edit the cell. To avoid this, you must use a specific mouse technique to select the cell.

Hover over the cell

Move your mouse cursor directly over the cell containing the hyperlink that you want to select.

Click and hold the mouse button

Press and hold down the left mouse button on the hyperlink. Do not release the button immediately as you normally would.

Wait for the cursor change

Keep holding the mouse button for about one to two seconds until the mouse pointer transforms from a hand icon into a hollow crosshair, which is the standard Excel selection cursor.

Release the mouse

Once the crosshair cursor appears, release the left mouse button. The cell is now selected, allowing you to edit the text or format the cell without opening the hyperlink.

Alternative Navigation Method: Instead of using the mouse, you can click on an adjacent blank cell and use the arrow keys on your keyboard to navigate onto the cell containing the hyperlink.

Free Microsoft Office alternative

Edit Spreadsheets Seamlessly with WPS Office Free

If you are frustrated by Excel's interface limitations or are looking for a more cost-effective productivity solution, WPS Office provides a lightweight, highly compatible alternative to Microsoft Office. Enjoy seamless spreadsheet editing, familiar formatting tools, and easy hyperlink management without the expensive subscription fees.

1. Download the Software: Visit the official WPS website and download the free WPS Office suite for your operating system.
2. Install WPS Office: Run the downloaded installer file and follow the straightforward on-screen instructions to set up the application.
3. Open Your Spreadsheets: Launch WPS Spreadsheets, open your existing Excel workbooks, and immediately continue working with full formatting compatibility.

100% compatible with Microsoft Excel formats including .xlsx, .xls, and .csvFamiliar and intuitive user interface allowing for an effortless transitionLightweight software installation with fast application loading timesBuilt-in advanced spreadsheet tools for efficient data analysis and formatting

Frequently Asked Questions

Why does Microsoft Word have a Ctrl+Click setting but Excel doesn't?

Microsoft Word prioritizes text editing and selection, making the Ctrl+Click requirement useful to prevent accidental navigation while typing or highlighting text. Excel prioritizes data entry and rapid interaction, so hyperlinks are designed to be clicked directly, assuming users will navigate standard cells using arrow keys or by clicking the white space within cell margins.

Can I disable automatic hyperlinks in Excel entirely?

Yes, you can stop Excel from automatically converting URLs into clickable links. Go to File > Options > Proofing, click on 'AutoCorrect Options', navigate to the 'AutoFormat As You Type' tab, and uncheck the box for 'Internet and network paths with hyperlinks'.

How do I edit the text of a hyperlink cell without opening it?

First, select the cell either by clicking and holding until the crosshair appears, or by using the arrow keys to navigate to it. Once the cell is selected, press F2 on your keyboard or click into the Formula Bar at the top of the screen to edit the text.

How can I select multiple cells that contain hyperlinks?

To select multiple hyperlink cells without opening them, click and hold on an empty adjacent cell that does not have a hyperlink, then drag your cursor over the range of hyperlink cells you wish to highlight.

Office App Problems