College of FAA, User Guides and FAQs, Microsoft Office, EXCEL - Link cells to worksheets

FAA Mark

This article applies only to Faculty, Staff and Students of the College of Fine and Applied Arts (FAA).

For more information, please contact Technology Services at FAA via:

• Phone: (217) 333-1986
• The Web: https://it.faa.illinois.edu/

Overview

For quick access to related information in another worksheet, you can insert a hyperlink in a Microsoft Excel worksheet cell.

Affected Customers

  • Customers throughout FAA.

Actions

  1. Select desired cell to use for link to worksheet
  2. Righ-click, select Hyperlink
  3. Select "Place in this document"

    excel cell2tab
  4. Select worksheet from available list
  5. Rename "Text to display" to the worksheet name or something custom

Support





Keywords:excel, work sheet, work sheets   Doc ID:73100
Owner:Michael C.Group:University of Illinois Technology Services
Created:2017-05-03 15:36 CDTUpdated:2017-05-03 15:51 CDT
Sites:University of Illinois Technology Services
Feedback:  0   0