Excel - Hyperlinked Cells: Episode 1360
1,242 views · Published 14 March 2011 · 1:13 · Indexed 26 October 2026
Channel: MrExcel.com · 2011 · Education
Microsoft Excel Tutorial: Selecting Hyperlinked Cells in Excel Without Activating the Hyperlink - Excel Tips and Tricks. Welcome back to the MrExcel netcast! In this episode, we will be discussing how to select hyperlinked cells in Excel without activating the hyperlink. This is a common issue that many Excel users face and can be quite frustrating. But don't worry, I'm here to show you a couple of simple tricks to solve this problem. First, let's address the most common scenario - you have a hyperlink in a cell and when you try to select that cell, it takes you to the website instead. This can be quite annoying, especially if you just want to make a simple change to the cell. So, how do we select the cell without activating the hyperlink? Well, one easy trick is to simply click outside of the cell and then use the arrow keys to navigate to the cell you want to select. This will allow you to make changes to the cell without activating the hyperlink. Another method, which may be a bit harder to remember, is to hold down the Ctrl key and then click the cell. This tells Excel not to activate the hyperlink, but rather just select the cell. This is the method that Microsoft recommends, but either one will work. So, next time you encounter a hyperlinked cell that you need to select without activating the hyperlink, remember these two simple tricks. I hope this episode has been helpful in solving your hyperlinked cell dilemma. Don't forget to subscribe to our channel for more Excel tips and tricks. Thank you for tuning in to the MrExcel netcast, and we'll see you next time for another informative episode. Happy Excel-ing! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Hyperlink selection issue (00:10) Clicking cell activates hyperlink (00:20) How to select cell without activating hyperlink (00:30) Two methods to select cell without activating hyperlink (00:40) Method 1: Click outside cell and use arrow key (00:50) Method 2: Hold down Ctrl key and click cell (01:00) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Avoiding hyperlink activation in Excel Clicking outside of cell in Excel Holding down Ctrl key in Excel How to select a cell without activating hyperlink Hyperlinks in Excel Learn Excel Selecting cell with hyperlink in Excel Selecting hyperlinked cell Tips for working with hyperlinked cells in Excel Using arrow key to select cell in Excel Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153040/ Today's Question: "How can I select a cell that contains an active hyperlink without actually clicking and following the hyperlink?" Bill shows us two solutions in Episode #1360. Learn Excel 97-2007 from MrExcel.
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920