| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Path and filename displayed in Excel
How do you configure Excel to display the full path and filename of the
worksheet. Thanks in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Path and filename displayed in Excel
=CELL(A1,"filename")
-- David Biddulph "falcios" wrote in message ... How do you configure Excel to display the full path and filename of the worksheet. Thanks in advance. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Path and filename displayed in Excel
=CELL(A1,"filename")
or maybe =CELL("filename",A1) -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... =CELL(A1,"filename") -- David Biddulph "falcios" wrote in message ... How do you configure Excel to display the full path and filename of the worksheet. Thanks in advance. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Path and filename displayed in Excel
Sorry I forgot to mention that I would like it to the default when I open
every worksheet. "David Biddulph" wrote: =CELL(A1,"filename") -- David Biddulph "falcios" wrote in message ... How do you configure Excel to display the full path and filename of the worksheet. Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i display the Filename without the path? | Excel Discussion (Misc queries) | |||
| Pulling in the path to a filename | Excel Worksheet Functions | |||
| Are there template footers for "Filename and Path" in Excel. How? | Excel Discussion (Misc queries) | |||
| Excel 2K: Putting Filename & path in footer | Excel Discussion (Misc queries) | |||
| Footer - FileName and Path | Excel Discussion (Misc queries) | |||
Linear Mode
