disable macros in excel on an open sheet

Next, Right-click the cell that includes the hyperlink, otherwise “B3,” and select “Paste Special > Paste Special… “ from the context menu to open the “Paste Special” window shown directly below.

Select cell “C3” and press the “Ctrl + C” hotkey to copy it to the Clipboard.

For example, enter “in cell “B3,” then input “1” in cell “C3” of the same spreadsheet.

Nevertheless, 2007 users can still remove links from spreadsheets using the “Paste Special” trick. As such, you can’t select that option in Excel 2007.

Not all Excel versions include the “Remove Hyperlink” context menu option.

Right-click on any cell and select “Remove Hyperlink”to convert all the links to plain text.

To remove all hyperlinks from a sheet, press the “ Ctrl + A“ hotkey to select all the spreadsheet cells.

Right-click on one of the selected cells and select the “Remove Hyperlink” option.

To remove multiple hyperlinks from an Excel spreadsheet, hold the “Ctrl” key and select several cells with URLs at once.

That will convert the hyperlink to a plain text URL.

Then, you can right-click that cell and select the “Remove Hyperlink” option on the context menu.

Open a blank Excel spreadsheet and enter ‘in cell B2.

If you’re using a more recent version of Excel, you can remove all the hyperlinks from a sheet with a context menu option. Using the Context Menu to Remove the Hyperlink Option If you want to have a list of plain text URLs, this is how you can remove all hyperlinks from Excel spreadsheets.

Disable macros in excel on an open sheet