One change that you may need to make is to repeat the header row on every page in Google Sheets. The on-screen layout is not ideal when converted to a physical page (although switching to Page Break view can help with that), and you often need to make a lot of changes to make your data print well. That's it! I hope you have found this tips page useful and informative.Spreadsheet applications like Microsoft Excel and Google Sheets can be difficult to print. See: Installing Macros for instructions on how to set up and use the macros provided in this tips page. The procedure RelinkSections is provided in case you should want to quickly relink all sections in your document.Ģ. 'Note: j provides the constant value to unlink all three headerooter types.ġ. I = oDoc.Range(0, Selection.Sections(1).Range.End).Sections.Count 'Get the index number of the added section Selection.InsertBreak Type:=wdSectionBreakNextPage When adding the new section the header text in section one is automatically applied to the header text in section two. In the illustration below I've started with a single section document containing header text and then added a section break. While this feature is very handy for repeating header and footer information in subsequent sections, I think it becomes a nuisance when you want to change part or all of the header/footer text in your new sections.

As shown below, the header text in section two is linked by default to the header text in section one. One thing that I don't like about the built-in user interface for adding sections is the header and footer of any new section inserted is linked to the previous section header and footer by default and 'stays that way' without further user actions. Sections in Word can be fickle (see InfoBit Blog Section Breaks). The purpose of this Microsoft Word Tips & Microsoft Word Help page is provide a VBA solution to automatic linked headers and footers.

Repeat header and footer in word