| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to insert filename in header without file extension
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to insert filename in header without file extension
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. "Andrew King" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to insert filename in header without file extension
"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. "trip_to_tokyo" wrote: 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. "Andrew King" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to insert filename in header without file extension
OP does not want file path and filename.
Filename only without the extension. Gord Dibben MS Excel MVP On Mon, 11 Jan 2010 21:15:01 -0800, trip_to_tokyo wrote: 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. "Andrew King" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to insert filename in header without file extension
My ComputerToolsFolder OptionsView
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 wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert file name in cell without .xls extension | Excel Discussion (Misc queries) | |||
| How to insert page numbers in a file, not the header or footer | Excel Discussion (Misc queries) | |||
| Getting only the filename with no extension | Excel Worksheet Functions | |||
| Can XLS automatically insert file properties fields into a header | Excel Worksheet Functions | |||
| File Extension (.xls) In Header | Excel Discussion (Misc queries) | |||
Hybrid Mode
