Join Dennis Taylor for an in-depth discussion in this video Using hyperlinks for rapidly switching worksheet locations and jumping to websites, part of Excel Tips Weekly.
- View Offline
- With Excel's Hyperlink feature,…you can set up links within worksheets…to websites, to different worksheets…within the same workbook, to a range name,…or even to another file, or in effect,…open another file, say, a Word file,…Excel file, PowerPoint file, something like that.…And if you simply type in a web address,…you automatically have a hyperlink.…For example, maybe I frequently use data…from the Census Bureau,…www.census.gov,…Federal Census Bureau.…
As soon as I type a web address, and press Enter,…an automatic hyperlink, and if I click this,…we're quickly at the census.gov site, there it is.…I don't really need that right now…but we can get there quickly and easily…from that button at any time.…Now, we've already created the hyperlink here.…If we right click this hyperlink,…we'll see we can Edit it.…Now, the Text to display is what we typed in,…and there's nothing wrong with that,…but on the other hand, depending upon who might use this,…you might say Federal Census Bureau…or US Census Bureau, however you want to say it.…
Skill Level Appropriate for all
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.