General discussion

Locked

INSERT FILENAME INTO A CELL?

By jposge ·
How do you imbed the filename of the spreadsheet into a cell? (I tried [file] and =[file] but these did not work.

This conversation is currently closed to new comments.

8 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

INSERT FILENAME INTO A CELL?

by calves In reply to INSERT FILENAME INTO A CE ...

If you want the file name to work as a hyperlink where the user can click and opn the related file, you need to highlight the cell, click on insert, hyperlink, file, and give the path to the file.

Good luck!

Collapse -

INSERT FILENAME INTO A CELL?

by jposge In reply to INSERT FILENAME INTO A CE ...
Collapse -

INSERT FILENAME INTO A CELL?

If you want to include the path as well you can use the formula
=cell("filename")

Collapse -

INSERT FILENAME INTO A CELL?

by jposge In reply to INSERT FILENAME INTO A CE ...
Collapse -

INSERT FILENAME INTO A CELL?

by khinton In reply to INSERT FILENAME INTO A CE ...

Try the following:
1. click Insert, hyperlink
2. click browse, find the file to link
3. choose cell and sheet
4. click OK
your link will be in the cell the cell reference pointer was in when you started.

If you just want the file name as a heading then use page setup, header footer tab and choose the file name option.
kevin

Collapse -

INSERT FILENAME INTO A CELL?

by jposge In reply to INSERT FILENAME INTO A CE ...
Collapse -

INSERT FILENAME INTO A CELL?

by parier In reply to INSERT FILENAME INTO A CE ...

If you have filenames in there that are going to point to different spreadsheets, you can assign hyperlinks to them, for emample, if you have one called testdata.

Click on that cell, hit ALT + K , then on top, there is a browse button, find the file that is associated with the link or name your on, then when done click OK, the text should now be blue and a hyperlink, click on it to test. Repeat steps a many times as necessary.

Hope this helps.

Collapse -

INSERT FILENAME INTO A CELL?

by jposge In reply to INSERT FILENAME INTO A CE ...
Back to Windows Forum
8 total posts (Page 1 of 1)  

Related Discussions

Related Forums