How to Insert a File Location in Excel 2007

An Excel worksheet can include a file path in a header of footer.

You can insert a file path in a Microsoft Excel 2007 worksheet. A file path specifies the file location and the file type in a file system. Use the Insert tab on the command ribbon to add this file path to a selected area of the worksheet. For example, the worksheet can contain the file path in a footer. A cell can also contain a hyperlink with a file path that opens another file window for additional reading.

Instructions

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

1. Open the saved worksheet.

2. Click on one cell to insert this file location. You can opt to select the cell's text for an embedded link.

3. Click on the "Insert" tab on the command ribbon.

4. Click on the "Hyperlink" button in the "Links" group. A dialog box for "Edit Hyperlink" will appear.

5. 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.

6. Click on the file in the scrollable window.

7. Click the "OK" button. The hyperlink will appear in the cell.

References

• Microsoft Office: Create, Select, Edit or Delete a Hyperlink