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.
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.