How to remove hyperlink in excel

Answer

To remove hyperlinks in Excel, right-click the cell containing the hyperlink and select "Remove Hyperlink" from the context menu. The text remains but the link functionality disappears.

Methods to Remove Single Hyperlinks

Using Right-Click Menu

Right-click any cell with a hyperlink. Select "Remove Hyperlink" from the dropdown menu. The formatting returns to normal text while preserving the cell content.

Using Keyboard Shortcut

Select the hyperlinked cell. Press Ctrl+Shift+F9 on Windows. Mac users need to use the right-click method since this shortcut doesn't exist on macOS.

Methods to Remove Multiple Hyperlinks

Removing Hyperlinks from Selected Range

1. Select all cells containing hyperlinks by dragging or using Ctrl+Click (Cmd+Click on Mac)
2. Right-click any selected cell
3. Choose "Remove Hyperlinks" (plural form appears when multiple cells are selected)
4. All hyperlinks disappear simultaneously

Removing All Hyperlinks from the Entire Worksheet

Press Ctrl+A to select all cells (Cmd+A on Mac). Right-click anywhere in the selection. Click "Remove Hyperlinks" to eliminate every hyperlink in the worksheet.

Using Clear Function for Hyperlinks

Clear Hyperlinks Only

Select the target cells. Navigate to Home tab on the ribbon. Click the "Clear" dropdown button in the Editing group. Choose "Clear Hyperlinks" to remove links while keeping formatting and content intact.

Clear Content and Hyperlinks

Select cells with hyperlinks. Press the Delete key to remove both content and hyperlinks. The cells become empty after this action.

Removing Hyperlinks with VBA

Basic VBA Code

Open Visual Basic Editor by pressing Alt+F11 (Option+F11 on Mac). Insert a new module. Enter this code to remove hyperlinks from selection:

 Sub RemoveSelectedHyperlinks()

    Selection.Hyperlinks.Delete

End Sub

Remove All Hyperlinks in Workbook

Use this macro to eliminate hyperlinks from every worksheet:

Sub RemoveAllHyperlinks()

    Dim ws As Worksheet

    For Each ws In ActiveWorkbook.Worksheets

        ws.Hyperlinks.Delete

    Next ws

End Sub

Some cells might contain multiple hyperlinks. Each hyperlink requires individual removal. Use a VBA macro for efficient bulk removal of complex hyperlink structures.

Preserving Formatting After Removal

Maintaining Text Appearance

Hyperlink removal changes the text color to default. Apply desired formatting manually after removal. Use Format Painter to copy formatting from other cells.

Restoring Original Style

1. Select cells where hyperlinks were removed
2. Navigate to the Home tab
3. Click "Cell Styles" dropdown
4. Choose "Normal" or preferred style
5. Text returns to standard worksheet appearance

Yes · 0 No · 0 Add Comment · 0

Add ·

Report