Share via

EXCEL. How do I insert the filename into the Header. I have inserted =CELL("filename") but nothing happens.

Anonymous
2023-04-13T17:35:32+00:00

EXCEL. How do I insert the filename into the Header. I have inserted =CELL("filename") but nothing happens.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-04-13T17:45:34+00:00

    =MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

    Insert the current Excel file name, path, or worksheet in a cell - Microsoft Support

    0 comments
  2. triptotokyo-5840 36,676 Reputation points Volunteer Moderator
    2023-04-13T17:49:42+00:00

    EXCEL. How do I insert the filename into the Header. I have inserted =CELL("filename") but nothing happens.

    Header & Footer tab

    Header & Footer Elements group

    Click:-

    File Path

     - or click:-

    File Name

     - depending upon your requirement.

    0 comments
  3. Anonymous
    2023-04-13T18:03:45+00:00

    If you want to add file name in Header instead of cell. trip_to_tokyo give the correct way.

    1 person found this answer helpful.
    0 comments
  4. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  5. triptotokyo-5840 36,676 Reputation points Volunteer Moderator
    2023-04-16T19:40:53+00:00

    If anybody’s interested I’ve just posted a Forum Article about this topic here:-

    How to insert a File Path or a File Name into an EXCEL Header

     - providing the full step by step process.

    0 comments