| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a function to print file name/path on a spreadsheet?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a function to print file name/path on a spreadsheet?
Page setup Header/footerCustom footer click the symbols to insert path
and/or filename -- Kind regards, Niek Otten Microsoft MVP - Excel "cchas80860" wrote in message ... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a function to print file name/path on a spreadsheet?
cchas80860 wrote: Nothing!
:-} |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a function to print file name/path on a spreadsheet?
cchas80860 wrote: Nothing!
Look at =CELL("filename") if you aren't talking about headers and footers. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a function to print file name/path on a spreadsheet?
If you are going to use CELL("filename"), you should include a cell reference
(any cell will do). Without it, the function returns the name of the last sheet that was recalculated. I always use CELL("filename", A1) now. Also, the workbook must have been saved for the "filename" method of the CELL function to work. Hope this helps, Hutch "Glenn" wrote: cchas80860 wrote: Nothing! Look at =CELL("filename") if you aren't talking about headers and footers. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I automatically print file path on documents | Excel Discussion (Misc queries) | |||
| Need to print path & file on ALL excel worksheets... | Excel Discussion (Misc queries) | |||
| Print file path | Excel Discussion (Misc queries) | |||
| How do you have the file path print on all pages? | Excel Worksheet Functions | |||
| print file path and location in a footer | New Users to Excel | |||
Linear Mode
