Friday, May 22, 2015

Printing a customized fixed header from MS Excel on every page

How to set a number of columns or rows in MS Excel to print on every page.  This should apply to MS Office 2007 and later.

In MS office ribbon go to the Page Layout Tab -> Print Titles


Then you will see this page setup pop up screen.


In the rows to repeat at top put in the range that you want to put on every page.  In this case I want rows 33 to 36 to repeat on every page I print.



Then select print preview to see the rows repeated on the top of every page.



Then Print your document.

Error opening PDF's In Chrome with Adobe Acrobat: PDF edit, convert, sign tools enabled

If you start having trouble opening PDF's in chrome or edge you might need to check for the " Adobe Acrobat: PDF edit, convert, sig...