#How to delete a header from excel how to

YouвЂ™ve now broken the link to the previous sections header or footer. Note that the button becomes de-selected. On the Design tab in the Header & Footer Tools area of the Ribbon, click the вЂњLink To PreviousвЂќ button. Now, double-click the header or footer area (depending on what youвЂ™re removing) on the page where you want to remove it. While itвЂ™s not obvious, the action you just took created a section break where your cursor was placed, and started your new section on the next page. On the dropdown menu, click the вЂњNext PageвЂќ option. Switch to the вЂњLayoutвЂќ on the Ribbon, and then click the вЂњBreaksвЂќ button. In your document, place your cursor at the very end of the page right before the page where you want to remove the header or footer.В For example, if you want to remove the header or footer on pageВ 12, place your cursor at the end of page 11. So first, youвЂ™ll need to create a separate section in the document (even if itвЂ™s just for one page), and then youвЂ™ll need to change the page layout for that new section to landscape orientation. WordвЂ™s page layoutВ features apply to whole sections of the document, and by default, your document is one large section. Unfortunately, you canвЂ™t just tell Word to change the layout of a single page (and headers and footers are considered part of the layout). Removing a header or footer for any page other than your first page requires a bit more work. By default, Excel 2013 does not repeat data headers, which.

#How to delete a header from excel how to

How to Delete a Header or Footer on Other Pages in Your Word Document Complicated Excel spreadsheets can span multiple printed pages, and without labels accompanying the data, the printout is often confusing. You can type different information there if you want, or you can just leave it blank.

This action removes the header and footer from the first page.

On the Design tab of that section, select the вЂњDifferent First PageвЂќ check box.

This also activates the Header & Footer Tools section on WordвЂ™s Ribbon. HereвЂ™s how to remove it.Дouble click the header or footer area to make it active. Usually, thatвЂ™s because itвЂ™s a title page. Very often, you wonвЂ™t want your header or footer to show up on the first page of your document. How to Delete a Header or Footer on the First Page of Your Document