filename in Cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a huge excel spreadsheet and will print it out. But before
doing so, I would like to insert a filename in a cell on this spreadsheet to
make reference where the actual file is residing in the server. I could do
this manually, but I thought Excel can do it auto via "Filename".

Thanks.
Leer587
 
not sure about that, but you can put the filename in a custom header or
footer for printing
 
A new file must first be saved..........then,

=CELL("filename",A1)

or, if you don't want the SheetName included......

=MID(CELL("filename",A1),1,FIND("]",CELL("filename",A1)))


Vaya con Dios,
Chuck, CABGx3
 
Back
Top