how to insert filename in header without file extension

  • Thread starter Thread starter Andrew King
  • Start date Start date
A

Andrew King

I'm looking for a way to insert the filename in a header without also
including the file extension. The header button in Excel inserts both with no
option to exclude the extension. I can write a macro but really just looking
for an automatic option. Thanks, Andrew
 
This works for me in EXCEL 2007:-

Page Layout

Page Setup group

Click on the arrow in the lower right hand corner. Page Setup should launch.

Header / Footer

Custom Header. . .

Click in the:-

Right section:

- in the lower right hand corner.

Click on the Insert File Path icon.

OK and OK again.

Print the single page and it will have the file path in the lower right hand
corner.

Please hit Yes if my comments have helped.

Thanks.
 
"Print the single page and it will have the file path in the lower right hand
corner."

- sorry, above should read upper right hand corner. Apologies.
 
OP does not want file path and filename.

Filename only without the extension.


Gord Dibben MS Excel MVP
 
My Computer>Tools>Folder Options>View

Enable "hide extensions for known file types"

Or a macro.


Gord Dibben MS Excel MVP

On Mon, 11 Jan 2010 20:33:01 -0800, Andrew King <Andrew
 
Back
Top