Comments on: Header and footer in Excel: how to insert, edit and remove

To make your worksheets look more stylish and professional, you can include a header or footer on each printed page of your document. Microsoft Excel provides a handful of predefined headers and footers to choose from, as well as allows creating your own ones. Continue reading →

Table of contents

Comments page 2. Total comments: 42

  1. Why is my footer covered up by the content of the spreadsheet?
    When I go to print I can't see it except a few words outside the margins of the actual cells.
    Thanks!

  2. Just thanks. This was a clear explanation and solved my problem.

  3. You don't explain here how to add formulas and this is the main question here. Bad response

  4. Hi,

    i would like to know how to amend an exiting date in header which is copied fromt he system and exported to excell

    e.g: date is Aug 20, xxxx i want to change to Sep 10, xxxx

  5. I need to justify left the text in the right header using VBA. Below is hte current code I have for the right header.
    wks.PageSetup.RightHeader = "&R" & "DocID: " & DocProperty("##ID##") & " Version: " & DocProperty("##REVISION##")

  6. There is NOT a way to EDIT a footer, like in Word. I do NOT want to create a new footer each time I change the Rev.date. old versions worked well. It is a shame that "software writers" like to show how complicated they can make a system work (or not work). Someone help me "EDIT" a footer.

  7. Hello,
    I received an excel document when open it shows the file name OVERHAUL-ebc. The main file name is actually OVERHAUL, but I want to get rid of ebc cause this is the author's name or signature. Also it is affecting my other new open excel docs whereby it appears Book4-ebc.
    Hoping you can help.
    Thank you.
    bonjing

  8. how do i insert a space between 2 footers in exce

  9. How To Add Text Above The Bottom Line in The Rightmost Footer Box

    Have you noticed that the text in the last footer text box is right adjusted AND at the bottom of the text box? Usually, this is what you want. For example, it is a great place to insert the "file name" when you are creating and printing multiple drafts of a spreadsheet.

    But sometimes, you want to insert text above the bottom line. There is a simple solution. Use Alt+Enter to insert a new line character in front of the text on the bottom line. This inserts a new line ABOVE the bottom line.

    If you want to use this trick, be sure to save your spreadsheet before you do. It is easy to mess up the format of the footer, and the easiest way to fix it is to exit the spreadsheet and load a new copy.

    Deacon John

  10. Is there any way to purge the drop-down list containing previous footer history? I want to delete confidential info that was included in a prior footer. Thanks!

  11. Is there a way to change the picture dependant on a cell selection.
    The scenario we have employees select the brand/ customer they are working on from a drop cell, and it changes the picture in the footer.
    Right now we have to have multiple variants of the same spreadsheet which is tedious.

  12. I have gone through the article on Header and Footer. This is rather applicable to PC, etc. What about Android mobile device? I shall be pleased to receive guidance from you.

  13. do How do change the back ground of th the cell

  14. How to add more than 3 columns in the predefined Header and footer section?

  15. How do I display both the current date and the date of one week ago in the header?

    1. Hello, Robert:
      Your's was a very interesting question that I had never considered. Entering current date is easy and can be done in the print page setup. Entering current or other date info into a worksheet cell is pretty easy, but headers and footers are special cases. You might need to consider entering the past date into the worksheet in a cell located at the top of the page.
      T any rate, it took some searching, but I think I found an answer. It will require a VBA solution. The explanation for which can be found here: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other-mso_2007/find-replace-in-excel-header/d0714cc7-3896-44a6-93d4-9d9b771c5ccf
      and also here:
      https://support.microsoft.com/en-us/help/213742/macro-to-change-the-date-time-format-in-a-header-or-footer

  16. nice post

  17. thanks svetlana

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)