How to Insert a File Location in Excel 2007

File Path in a Header or Footer
1. Open the saved worksheet.
2. Click on the 'Insert' tab on the command ribbon.
3. Click on the 'Header and Footer' button in the 'Text' group. The 'Design' tab will appear.
4. Click on the header or footer text box.
5. Click on the 'File Path' button in the 'Header Footer Elements' group. A code will appear in the text box.
6. Click away from this text box. The workbook's file path will display in the text box.
File Path in a Hyperlink
7. Open the saved worksheet.
8. Click on one cell to insert this file location. You can opt to select the cell's text for an embedded link.
9. Click on the 'Insert' tab on the command ribbon.
10. Click on the 'Hyperlink' button in the 'Links' group. A dialog box for 'Edit Hyperlink' will appear.
11. Click on the down arrow of the 'Look In' box for the location of the file. For example, the file may be saved on the desktop.
12. Click on the file in the scrollable window.
13. Click the 'OK' button. The hyperlink will appear in the cell.