Page Setup - Header/Footer - combined feature requests
This idea combines a host of ideas which all call for similar functionality. The individual postings score minimal votes but together they add to 75 votes. I raise this to combine the feature requests, so that it gets prominence as I would dearly like to see this addressed.
Features for the Header / Footer:
1. include variables based on a cell reference
2. more than one Picture and Shapes
3. Print and save dates
4. Number of pages of the sheet and of the workbook
5. Add file properties (quick parts in Word)
6. Option for the header/footer on the first page only
I think Malcolm in the following post describes the mechanism the best:
https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/18633517-enable-headers-and-footers-to-include-variables-ba (26 votes)
Here is a list of all the similar feature requests which this post aims to roll up and bring to the forefront. I will post the link to this post, in each of these below, and ask people to vote again to see how many votes we get.
(15 votes) https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/20305687-i-need-more-options-and-control-for-excel-headers
(7 votes) https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10894572-header-and-footer-like-word
(5 votes) https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/11306457-allow-option-for-header-on-the-first-page-only
(5 votes) https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/18572680-header-and-footer
(4 votes) https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/34267315-being-able-to-change-the-date-format-in-the-header
(4 votes) https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/32559508-using-various-dates-in-header-footer
(3 votes) https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/36516010-provide-access-to-fields-like-savedate-like-in-m
(2 Votes) https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/34715779-we-don-t-have-options-to-add-border-line-in-header
(2 Votes) https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/20015278-ability-to-easily-add-custom-properties-to-cells-a
(1 Vote) https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/39756547-including-a-tool-to-make-to-number-pages-within-a
(1 Vote) https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/39439864-possibility-to-insert-quick-part
Hope this is helpful.
Andrew Taylor commented
Another feature of making references in headers/footers would be the ability to reference a cell relative to one of the four corner cells that make up the particular page in addition to any other methods of referencing cells available in cells.
An example of what I'm talking about is the page headings in the telephone directory. This is where there is an alphabetically sorted list of people over a number of pages and one wants the header to be something like "Brown, C - Gates, W" where on that particular page the first entry is Charles (Charlie) Brown and the last entry is William (Bill) Gates. The first part of the header would reference the cell based on the top-left cell on the page. The second part would reference the cell based on the bottom-left cell on the page.
As the person who you say "describes the mechanism best" I will definitely vote for this and thanks for summarising it all. The approach to headers and footers, even its appearance, shows that it has really not been thought about since the days Excel was first launched.
It's something people have been asking to be approved for years and yet instead we get glossy new charts, "ideas" and such like which must be far more difficult to program and less useful to the wider audience.
Come on Microsoft, bring headers and footers in to the late 20th century at least.