How Excel prints a fixed header and footer

Excel sets the function of printing the top header row, as shown in the following figure:

Version 2003: File > Page setup > Worksheet

Versions 2007 and 2010: page layouts > Page settings > Print titles

But Excel doesn't give us the ability to set a fixed print footer, when it's not necessary, you can only turn the footer into a picture, insert it as a footnote, and then look at the size of the picture in a millimeter and a millimeter, until it looks like it. What's more, if we need to have a dynamic summary value in the end of the fixed table, then ... Cry ....

In fact, also not to cry that step, the SUBTOTAL function can help us achieve each page finally automatically generate a dynamic summary value, the operation process is very simple:

How it works, crawl into the cell yourself try it ^_^