Exam 77-420 Microsoft Excel 2013 1. Create and Manage Worksheets and Workbooks 1.2 Navigate Through Worksheets and Workbooks: Hyperlink to a Worksheet

Insert ->Links-> Hyperlink Link to a Spreadsheet Say you wanted to link to the original data sheet. You can create a hyperlink that goes to another sheet in this workbook.   Before You Begin: This lesson shows a sample workbook: Sales 2013.xlsx. This workbook has a sheet named Original Data as well as the Sparkline 2 sheet that we created earlier.   5. Try This: Link to a Sheet Click on the Sparkline. Go to Insert-> Links-> Hyperlink. Select: Place in the Document. Click on the Original Data spreadsheet.   What Do You See? When you choose Place in This Document you should see a list of Sheets and Defined Names that you can link to.   Click OK and keep going...   Where Have You Seen This Before? In Microsoft Word, you can hyperlink to the text or picture that has a Bookmark.