Scribd
Upload
34 views2 pages

Linking Data and Spreadsheets

The document discusses how to insert worksheets and hyperlinks in Excel. It explains the two types of hyperlinks - relative and absolute - and how they differ in terms of file location dependence and whether the link will break if files are moved. It also provides instructions for opening the Insert Hyperlink dialog box and editing an existing hyperlink.

Uploaded by

Aryan Agarwal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as RTF, PDF, TXT or read online on Scribd
34 views2 pages

Linking Data and Spreadsheets

The document discusses how to insert worksheets and hyperlinks in Excel. It explains the two types of hyperlinks - relative and absolute - and how they differ in terms of file location dependence and whether the link will break if files are moved. It also provides instructions for opening the Insert Hyperlink dialog box and editing an existing hyperlink.

Uploaded by

Aryan Agarwal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as RTF, PDF, TXT or read online on Scribd
You are on page 1/ 2

To insert a new worksheet:

- press Shift + F11, or


- click on Insert Worksheet beside the sheet tabs, or
- click on Home tab > Cells group > Insert > Insert
Sheet.

A hyperlink is a coloured and underlined text or


graphic, which works as a reference to a specific
location that the user can jump to by clicking on the
link.

Excel supports 2 types of hyperlinks - relative and


absolute.

- A relative hyperlink is a hyperlink containing a partial


address, which is relative to the address of the
destination file.
- Relative linking is possible only when both the source
and destination files are on the same drive or location.
- The link will break if any of the files is moved from its
location.

- An absolute hyperlink is a hyperlink containing the


full address of the destination file.
- Absolute linking is possible without the source and
destination files having to be on the same drive or
location.
- The link won’t break if any of the files is moved from
its location.
To open the Insert Hyperlink dialog box:
- press Ctrl + K or
- click on Insert tab > Links group > Hyperlink.

To edit an existing hyperlink, select the hyperlink cell


and click on Insert tab > Links group > Hyperlink.

You might also like