How to remove hyperlinks in Excel

How to remove hyperlinks in Excel
(Image credit: Microsoft)

Too many links and too many spreadsheets. Sometimes you've got to cut them down, but in the case of spreadsheets, they're a necessary evil. If you want to wipe out a swath of hyperlinks in one move, we got your back. We're going to teach you how to remove hyperlinks in Excel.

Looking to become an Excel guru? We've covered other Excel how-to topics, like how to subtract in Excelhow to filter in Excel, and how to make a graph in Excel.

But today we're going to walk you through how to remove hyperlinks in Excel.

Step 1. Find the text you wish to unlink and right-click it.

Step 2. Click Remove Hyperlink.

How to remove hyperlinks in Excel

(Image credit: Microsoft)

Step 3. To remove all hyperlinks from Excel, you can simply press Ctrl + A to select all cells, right-click, and then click Remove Hyperlinks again.

Step 4. To turn off automatic hyperlinks, go to File > Options > Proofing.

How to remove hyperlinks in Excel

(Image credit: Microsoft)

Step 5. Now click AutoCorrect Options, and then select the AutoFormat As You Type tab.

How to remove hyperlinks in Excel

(Image credit: Microsoft)

Step 6. Finally, uncheck the Internet and network paths with hyperlinks box.

It's really that simple. You don't have to juggle the Pythagorean theorem to enjoy the wonders of hyperlink removal. Don't go pulling your hair out over Excel. There are plenty of Microsoft Excel tips and tricks to make your life easier.

Category
Arrow
Arrow
Back to MacBook Air
Brand
Arrow
Processor
Arrow
RAM
Arrow
Storage Size
Arrow
Screen Size
Arrow
Colour
Arrow
Storage Type
Arrow
Condition
Arrow
Price
Arrow
Any Price
Showing 10 of 279 deals
Filters
Arrow
Load more deals
Rami Tabari
Editor

Rami Tabari is an Editor for Laptop Mag. He reviews every shape and form of a laptop as well as all sorts of cool tech. You can find him sitting at his desk surrounded by a hoarder's dream of laptops, and when he navigates his way out to civilization, you can catch him watching really bad anime or playing some kind of painfully difficult game. He’s the best at every game and he just doesn’t lose. That’s why you’ll occasionally catch his byline attached to the latest Souls-like challenge.