This video explains how to add an interactive hyperlink to an object in Excel to open a webpage in the default browser.
(upbeat music) - [Instructor] For a quick way to provide access to a webpage or another file, you can add a hyperlink to one of your cells or to other elements in your workbook. Start by selecting the object in your workbook. This could a picture, a cell or an element in a chart, for example. Then in the insert ribbon, click the hyperlink button. Alternately, you can right-click your object and select hyperlink from the menu that appears. On the left side of the hyperlink window, choose the type of link you want to create.
So for example, to link to a webpage, select existing file or webpage, and then type or paste the address of the website into the address field. Note that this must be the complete address, including the http or https:// at the beginning of the URL. Click OK. And now whenever you click the object you added the hyperlink to, that website will open in your default browser.
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Working with references
- Freezing and locking
- Automatic data population
- Recovering lost work
- Finding named ranges
- Formatting cells and applying styles
- Applying international currency formatting
- Inserting hyperlinks
- Creating dropdown lists
- Hiding columns and rows
- Password protecting a workbook
- Restricting editing
- Adding headers and footers
- Locking cells