How to Insert a File Location in Excel 2007

Save

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.

File Path in a Header or Footer

  • Open the saved worksheet.

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

  • Click on the "Header and Footer" button in the "Text" group. The "Design" tab will appear.

  • Click on the header or footer text box.

  • Click on the "File Path" button in the "Header & Footer Elements" group. A code will appear in the text box.

  • Click away from this text box. The workbook's file path will display in the text box.

File Path in a Hyperlink

  • Open the saved worksheet.

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

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

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

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

  • Click on the file in the scrollable window.

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

References

  • Photo Credit Jupiterimages/Photos.com/Getty Images
Promoted By Zergnet

Comments

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!