Excel Magic Trick 934: HYPERLINK Function and Hyperlink Feature (13 Examples)

Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT934Start.xlsx

https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT934Finished.xlsx

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm
See how to use:
1) Hyperlink Feature to open a web address or file (Ctrl + K)
2) Hyperlink Feature: format as you type
3) Hyperlink Feature: format as you type: how to turn this option off: File, Options, Proofing, AutoComplete, AutoFormat Tab
4) HYPERLINK Function to open a web address with content in cells
5) HYPERLINK Function to open a web address with address and friendly named entered as text using double quotes
6) HYPERLINK Function to open a file in same folder as open file
7) HYPERLINK Function to open a file on a different drive
8) Hyperlink Function to go to a cell on the same sheet using the file path method
9) Hyperlink Function to go to a cell on a different sheet using the file path method
10) Hyperlink Function to go to a cell on a different sheet in a different workbook
11) Hyperlink Function to go to a Defined Name on a different sheet in a different workbook
12) Hyperlink Function to go to a cell on a different sheet using the file # sign method in order to build a Table Of Contents
13) Hyperlink Feature to Create Link back to Table Of Contents

whenever I select a country say Australia from the drop down it takes me to the That Tab within the excel

Create Table of Contents to jump to different sheets worksheets Tabs in the Excel workbook

Видео Excel Magic Trick 934: HYPERLINK Function and Hyperlink Feature (13 Examples) канала ExcelIsFun