Excel Different Header On Each Page

Page Layout Tab; Expand the Menu option on the bottom right of the Page Set Up Group. I have about 20 different pivot tables in the one spreadsheet that look toward 2 different dynamic data ranges, instead of having to refresh all 20, I just need to refresh 2 (1 of each) Rajagopal Can you make a single pivot table from multiple dynamic ranges on different worksheets in the same work book?. Right-click and then select "Format Cells" from the popup menu. You can also change a print option to see that line at the top of every page when you print out the spreadsheet. If you want to get started coding in Excel, make sure to check out this chapter by chapter VBA tutorial. Headers and footers in an Excel spreadsheet offer a simple way to put repeating information at the top of every printed page of your spreadsheet. you may need a different footer on every page or a series of pages. Sometimes, no matter what options are selected the 'Repeat as header row at top of each page' option doesn't work as expected, if at all. but if you press different header. Or maybe you have a document where you don't want the header on the first page. View > Headers and Footers, then type or insert fields; can also double-click in existing header or footer regions. Adding Header and Footer. When you add Headers & Footers, Excel takes you to Page Layout view. MS Word provides an option to create different headers and footers within the same document. I have done some research and folks are saying cick on View and then Header/Footer but there is no Header/Footer info there. You will have to insert section breaks. After grouping has been done, you should apply page break to both table controls, as both inserts a new page when they finishes printing entries for each document, to print both sales header and details in different pages. Open the spreadsheet in Microsoft Excel 2013, cl ick the Insert tab and then click Header & Footer in the Text group to add a blank header to the top of each page of the spreadsheet. In this tutorial we’ll look at how to insert a blank row at those changes. [See also Excel, Outlook, PowerPoint, and Word "subheaders" at byte offset 512 (0x200). Contiguous, uninterrupted data tables are much easier to work with,. Add image to the headers or footers. Adding a header (or footer) to an Excel sheet is a simple task using Excel's Page Layout view. For many people, different pages may have different contents in their worksheets. Place the cursor inside the header or footer where you would like to place the date (you may want to align it using the paragraph formatting options). The next area is for Headers & Footers, which will take you to the page layout view - here you can add headers and footers for the entire page. If you select this box when your First Page Header is active, you will then be able to put one header on the first page and a different header on all the subsequent pages. In this article, we will learn how to put a line at foot of print page in Microsoft Excel 2010. Or different footers for each page printed from a single worksheet? This would be done manually in most cases. Formatting documents in Word can be extremely frustrating. I want to have it dynamically generated and not "hard coded" into the sheet because new columns are added all the time and it would be pain to reformat the "merged and centered" cell on each page each time. Create a text form field that lets you enter text once and have it appear automatically elsewhere in the document, such as the date shown in the file's header. Re: VBA Code for Headers and Footers. Repeating Column Headers on Every Page in SSRS Doesn't Work! …Or Does It? August 20, 2011. This is unfortunate; I wanted it to scale each section of the pivot table individually to one page. Under the Header & Footer Tools Design Tabin the Options group, choose Different First Page. In Page Layout view, the worksheet is displayed as it will appear on the ____. 2) Clicks on the bookmark and goes to the form. Since they are not visible in the normal worksheet view, headers and footers are added to a worksheet when it is printed. When they Click on Insert>Page Number every single page gets the same number in the footer. By default, the headers and footers of each section are connected to those of the sections before and after it. In Excel, there is a separate option called “Print titles” that only print the titles on every page. I am just messed up with that. On the "Header and Footer" toolbar click the "Page Setup" button. Set and Code. Click the Header or Footer button. Can anybody please help me out. Adjust the margins of your document. Here is how to insert your company logo on each page of your Excel work book. Let’s first have a look at how you can add a header to your document on Google Docs. Perfect! Finding More Information. In this tutorial, we will teach you how to repeat row and column titles in Microsoft Excel. It would be great if you bookmark this page and keep on visiting t o new codes every time. Insert a Watermark. So to repeat headers on all pages: Under Design Pane - > at the bottom Column Groups - > click on drop down. width) - A header on each tab. Unlike Word, XL doesn't have separate "first page" headers and footers - it prints headers and footers on every page. Can anybody please help me out. Odd Page - Insert a section break and start a new section on an odd-numbered page. In Microsoft Excel, the column headers are named A, B, C, and so on by default. Any other ideas on how to print multiple page Pivot table with headings on each page? My setup: A workbook with many worksheets. In this post, we will discuss how to enter automatic numbering into the header or footer sections of a document in Microsoft Word 2013. Step 2: Click inside the left, center or right Click to add header box and type the title of the spreadsheet. MS Word 2010: Create a different header for the first page This Word tutorial explains how to create a different header for the first page of a document in Word 2010 (with screenshots and step-by-step instructions). I'm not familiar with VBA code, but I found the code below online and modified it a bit in an attempt to center the headers on each worksheet. Long column headers can even cause the dreaded horizontal scroll that everyone hates so much. Items, such as document titles, chapter titles, and page numbers, which often go into headers and footers, are best added as fields. Excel Tables are a powerful feature introduced in Excel 2007. ; Link to previous: Uncheck if you want to use a different header or footer for that section. Notice that The page header & footer (if any) appear on each page, giving you a true preview of the printed output. Bates numbering is a method of indexing legal documents for easy identification and retrieval. If a title has been specified with the TITLE statement, that title is used. On that tab, select the “Different First Page” option. Header and Footer. Diagonal headers in Excel. Select View > Header and Footer. Defining Different First Page and Different Odd and Even Pages If the report requires a different header and footer on the first page of the report; or, if the report requires different headers and footers for odd and even pages, then you can define this behavior using Microsoft Word's Page Setup dialog. Merge Excel Worksheets with VBA. Choose Select All Sheets from the resulting shortcut menu. These instructions are mostly the same as for removing the header and footer text when printing pages from the Internet, but a few visitors have requested I add this page as well so here goes. Step 2 - Add water mark in Excel Worksheet Header. How to Print Worksheets and Workbooks in Excel 2016. Adding a header (or footer) to an Excel sheet is a simple task using Excel's Page Layout view. Report Directly from Excel Tables. excel - individual headers/footers for each page? I'm trying to create a perpetual calendar via Excel: I've got it set over 12 pages as one continuous table, so that I can remove cells in "column B" to change the day of January 1st, and that change will flow down the rest of the year. Note, if the margins are too small, a header or footer may overlap data, so be sure to leave enough margin if you want to use one; Sheet Rows to repeat at top - this is where you can select column headings to print on every page. Choose the "Header/Footer" tab when the "Page Setup" window opens. Note: The Print Titles command will appear dimmed if you are working in cell On the Sheet tab, under Print titles , do one or. Add headers, footers, and page numbers. Note: You can only see and edit page numbers, headers, and footers when a document is in "Print layout" mode. Makes sure that the row headings stand out C. You can even put a picture in a header or footer. Page setup options can be set with a combination of CSS style properties and with XML. Header/Footer – lots of options here, add a page number, or add the worksheet name by doing a custom footer. Insert Page Numbers Format Page Numbers Page Numbering Select “Start at iii” 5. The fact that the first row contains column headers can be made optional, for example by passing a Boolean argument to our method. I was able to print both pages only after I highlighted the whole pivot table and set the print area. When editing your Header or Footer, you can add different widgets, such as page numbers, date & time, document info, or other quick parts. Bates numbers appear as headers or footers on the pages of each PDF in the batch. Skip to Navigation Skip to the Content of this Page Back to the Accessibility Menu Guiding Tech. Choose Page Setup dialog box » Header or Footer tab. 5) Click on the main area of the document to finish. Headers hd_ft. For example, you might create a footer that has page numbers, along with the date and time. If you want to make a different header for each page, then you will have to insert a section break for each page. Hi I need help to find out why Excel 2007 on windows 7 pro file open and print with different margins on different computer Computer one opens and prints a custom. Identify each page with the first two or three words of the title and with the page number placed on the upper right hand corner of the page. You can freeze a row so that it always appears on the screen, even if the reader scrolls down the page. (This box is also useful when you want headers and footers on every page except the first. Is there a way to assign headers and footers to different pages?. Then you can assign unique header and footer to each section. Formatting documents in Word can be extremely frustrating. Here’s how to do it: Open up your Microsoft Word 2016 Document. Bates numbers appear as headers or footers on the pages of each PDF in the batch. Drag a list control to your report body. Many elements (such as Page Number, File Name, and Current Date) are found on the ribbon. , section break instead of a page break), then you can unlink the footers and place a different footer for each section. Notice that The page header & footer (if any) appear on each page, giving you a true preview of the printed output. I want to have it dynamically generated and not "hard coded" into the sheet because new columns are added all the time and it would be pain to reformat the "merged and centered" cell on each page each time. On the Insert tab, in the Text group, click Header & Footer. Click somewhere else on the sheet to see the footer. Defining Different First Page and Different Odd and Even Pages If the report requires a different header and footer on the first page of the report; or, if the report requires different headers and footers for odd and even pages, then you can define this behavior using Microsoft Word's Page Setup dialog. width) - A header on each tab. How to apply different headers or footers on each page on an Excel spreadsheet? By default, when inserting header or footer into a worksheet, the header or footer content will be applied to all pages. x, how can I insert an APA format compatible header in a pages document? The header on page 1 needs to contain the words "Running head:" before the paper's title, while on page 2+ the words "Running head" are removed. Ask Question Deleting a single header or footer will delete all headers/footers on each page of your document, just as editing the text in a single header or footer will change the text in the header/footer on each page of the document. Open your Microsoft Office document. So, the problem lies with the fact that: 1. You can refer to the below image. In this article, we will learn how to put a line at foot of print page in Microsoft Excel 2010. There are a variety of conditional formatting styles, including icons that will adjust based on the data. Every font takes up a different amount of space on the page, even if claims to be the same size. I have set it up so that the first page has one image in the header, and any subsequent pages have a different image in the header. column headings) on each page in the print out. If your worksheet spreads over more than one printed page, you can define rows and columns to repeat. This will make that change for the FIRST page only. Using Google Documents …. 25 centimeters from the page edge. Many people use the header section for information like page numbers. Link to previous : Uncheck if you want to use a different header or footer for that section. Headers and footers are lines of text that print at the top and bottom of each page. I want to have it dynamically generated and not "hard coded" into the sheet because new columns are added all the time and it would be pain to reformat the "merged and centered" cell on each page each time. How to Print Titles in Page Pages on Google Doc Spreadsheet. If you want to make a different header for each page, then you will have to insert a section break for each page. The path to the test data file can be passed as an argument to the main method, or the user can be allowed to select a test data sheet, for example using JFileChooser. Introduction Page layout Printing area Printing Page break View page breaks. In Microsoft Word, you can create page headers that display text, images and document information such as the page number. You cannot enter text or insert positioning characters on the same line as the cell content. To display the same page number on side-by-side pages On the Page Setup tab, click the arrow at the bottom of the Page Setup group. Once done, close the header design tab. so that when you print the file, each page indicates the sheet it came from. Each application has a different set of tabs which expose the functionality that application offers. use page numbering that starts at 1 for each section of your document (for example, different chapters in the same document). Below, we’ll show you how to place the document’s file name, either with or without the full document path, within the header or footer of your document. On the Insert tab, in the Text group, click Header & Footer. In Microsoft Excel, by default, a table or graph begins in position A1. Second, Department C did not start in a new page because its data is not extended to Page 3, so Department C already successfully keeps the group together in one page, no change is needed. With a hat-tip to Susan Harkins at TechRepublic. Select the field you want to total on and the type of total you want. TIP: The text that you are trying to center must be in the left most cell (first cell) of the selected range. A Chapter field in a page header always picks up the highest heading level on a page, even if you have specified a lower level in the Layer box. Open a worksheet and, on the toolbar, click on File, Page Setup and then the Header/Footer tab. If you're using Excel 2007, go to File, Page Setup and then open the. If you move the mouse to the corner of a page while in Page Layout View, you can click to hide the white space in the margins. Page setup options can be set with a combination of CSS style properties and with XML. One quick way is to choose the Narrow option under the Margins command in the Page Setup section of Excel’s Page Layout menu. To work around the issue, you could do as following: 1. In Excel, just about all efficient Excel spreadsheet designs contain Headers and/or Footers where appropriate. (4) And then you will see the Header on the top of each page. Creating Different Footers for Each Page December 13, 2009 by Sue Huckle If you are writing a report or thesis, you may need a different footer on every page or a series of pages. I can't help but wonder if this formatting anomaly is tied to a cascading style. For this simple example, even with the three header rows, we can easily get the row and column headers to repeat on each page by going to the Tablix Properties window and checking the Repeat header rows on each page and Repeat header columns on each page properties. Get is crazy. You can modify your Header or Footer to have a different first page. Excel Copy and Paste Version of VBA Code This code in a VBA Macro will simply copy and paste the row with the header from a different sheet (called Header, here) and paste it on our Data sheet after Inserting a new Row 1. By default, new workbooks do not have headers or footers. Divide the document into different sections using Section break to achieve this. The column headings now only appear once, at the top of every page. In this post, we will discuss how to enter automatic numbering into the header or footer sections of a document in Microsoft Word 2013. If you want to change the Header or Footer size on the second page, scroll down and click anywhere within the SECOND page of the letter. Actually, each Section can have up to three different Headers (and three different footers), which is the case if you have selected "Different odd and even" and "Different first page" (also on the Header & Footer Tools Design tab). One part of the Google Docs suite is the word processing application. Go to File Tab -> Print -> Print Setup -> Margins. If you move the mouse to the corner of a page while in Page Layout View, you can click to hide the white space in the margins. Designing your Header or Footer. In the toolbar that appears, choose the Page setup image and then the tab Layout. Background This solution requires a. The first task is quick and easy; the second is a lot more interesting. In Excel, there is a separate option called "Print titles" that only print the titles on every page. Any other ideas on how to print multiple page Pivot table with headings on each page? My setup: A workbook with many worksheets. There are four worksheets in the excel file when I load directly into excel. Plus, Word updates the content, which saves you the effort of doing it manually. How to Print Worksheets and Workbooks in Excel 2016. I have done some research and folks are saying cick on View and then Header/Footer but there is no Header/Footer info there. Important Note: This article is for Word 2003 and earlier. In your case, since pages 2+ have the same header, they can have the same page style, but the first page must have a different page style in order to have a different header. In Excel 2016 VBA and Macros, Excel authorities Bill Jelen (Mr. Initially the first page header will be blank. Enter and format the header content in the displayed header field. Once the header is active, you will see a Header & Footer Tools Ribbon Tab at the top of the screen. (3) Enter the text or insert an image (such as your company logo) on the header. That way, the header row or column will be printed on each page. Excel provides a bunch of default headers and footers. In Google Doc Spreadsheet, it is in a combined form. If we click on Preview pane, we will notice report data gets displayed into three pages with no headers on all pages except the first page. Quick Tip for Microsoft Excel 2010. Now you can leave your data in an uninterrupted table in the sheet. In Microsoft Word, you can create page headers that display text, images and document information such as the page number. How to Remove a Header from the Second Page. so that when you print the file, each page indicates the sheet it came from. Every sheet has different filled rows, some 30, some 13, some 5 etc. Hi there, I'm hoping someone can help. Then change the footer or header again for the next page, and so on. Headers and footers. Some time ago I was asked whether it was possible to add a Page. Microsoft Access reports can have report headers/footers and page headers/footers. If you often have to print large and complex Excel worksheets, I am sure that you face this problem as often as I do. Defining Different First Page and Different Odd and Even Pages If the report requires a different header and footer on the first page of the report; or, if the report requires different headers and footers for odd and even pages, then you can define this behavior using Microsoft Word's Page Setup dialog. Let's look at both. Headers and footers in XL exist in three parts each: LeftHeader, CenterHeader, RightHeader, LeftFooter, CenterFooter, and RightFooter - you'll need to change each one that is used or hidden. Often Word completely disregards the 'repeat header row' setting - leaving you with a table that just doesn't behave. For ex: Brown 1. To have Excel show column headers at the beginning of each page during a print job: [ad#in-post-ad] Select “View” from the drop-down menus at the top of Excel; Click on “Header and Footer…” In the “Page Setup” window you should see 4 tabs, click on the “Sheet” tab. Hi I need help to find out why Excel 2007 on windows 7 pro file open and print with different margins on different computer Computer one opens and prints a custom. Open the drop list on the Header text box and scroll it to see the pre-defined headers. On the Insert tab, in the Header & Footer grouping, click either Header or Footer. Page numbers are the most popular information to include in headers and footers, but I'll show you other uses for them and a few tips and tricks for creating them. Used to make aggregated data stand out. And the rest of the pages will have the same header except for the last page. (Click inside the footer to show this tab. Print headers and footers on the first page only. Import a list of known contacts If you plan to use email to keep in touch with existing customers, then your email list can be built largely by importing your existing customers details. Adding page numbers in Word is slightly different than editing the header. On the View tab, in the Workbook Views group, click Page Layout, to switch to Page Layout view. I want to have it dynamically generated and not "hard coded" into the sheet because new columns are added all the time and it would be pain to reformat the "merged and centered" cell on each page each time. Classroom; College; Lifestyle; Technology; Tests; Vocabulary; Home » Technology; How to Sort Excel Data When a Header Is on Multiple Rows especially when you're working with numerical data, Excel automatically detects the correct header row -- but. The first way is good if you want to automatically number pages in Google Docs, from the beginning until the end or skipping the first page (which we will explain later in more details). If you select this box when your First Page Header is active, you will then be able to put one header on the first page and a different header on all the subsequent pages. Basically, I need the first 2-3 pages with no headers or footers, I need the next page to have a certain header (lets say it is page 4). For 2003 and below. Locate Header on the Ribbon and click on it. How to Print a Table Header on Each Page in Word 2013. What's the solution to creating different headers? A. The reason is because where the header and footer shows up depends on the theme you chose for your presentation. but if you press different header. Adding Header and Footer. In the VBA example on this page I showed you how to change the Cell menu and I used the Activate and Deactivate event of the workbook to call a macro to create and delete the menu controls. In the Page Setup dialogue box, within the Page tab, change the First Page Number field from Auto to the number that you want to show/print. For each location there can be one or more items. You can click the various buttons to insert useful pieces of information, like the page number, number of pages, the date, file name, file path, and more. Click the Header and Footer Tab; Custom Header. Headers and footers in an Excel spreadsheet offer a simple way to put repeating information at the top of every printed page of your spreadsheet. In Word, page numbers and headers and footers look like the same thing, but they aren't. 3) Select everything inside the header or footer box. For worksheets, you can work with headers and footers in Page Layout view. 2019-10-01 Udar Gromov Office and Browsers 0. Click in the center header section box. Then, in the Page Setup dialog box, click the Layout tab, and under Headers and Footers, click Different Odd and Even. To add or edit a header or footer, click the left, center, or right header. This is article explains, How to change "page headers' for different pages in MS Word. Excel 2003 - Different Header for each page I have the same problem in Word, but understand now that you enter "Section Break" to achieve different header/footer on each pagebut Excel doesn't give you that option. To display the same page number on side-by-side pages On the Page Setup tab, click the arrow at the bottom of the Page Setup group. ) The current template inherits from the specified header template in the first readable template store in the current path. Like say, on the first page, header/ footer of report should be some text and on the second page it should be some different text. In the main menu bar, choose Insert > Break > Section Break (Next Page). So if you make each page a separate "section" (i. Today, I will explain a Word macro that removes all the headers and footers from an active document. in case you want different, use different file for each page. Go to the end of the first pa. Around our office, we do a lot of wills. TIP: The text that you are trying to center must be in the left most cell (first cell) of the selected range. ) Check the "Different odd and even" box to use different headers or footers on facing pages, as is done in most books. To assign different page settings to different parts of your publication you will need to insert a section break. Total Row III. Page numbers are the most popular information to include in headers and footers, but I'll show you other uses for them and a few tips and tricks for creating them. But with some defined names this proved possible. Creating Different Footers for Each Page. There are four different styles of page numbering you can choose from. Display Row and Column Headers on Multiple Pages (Report Builder and SSRS) 12/09/2019; 2 minutes to read +2; In this article. Here is one common example. Header and footer are areas at the top and the bottom of a page. Add your different header and footer elements to the odd and even pages (Excel tells you when you are in an Odd or Even PageHeader) (2). In this tutorial we’ll look at how to insert a blank row at those changes. You can also choose whether you want to show a grand total, totals as a percentage of a grand total, display totals in the header, or display totals in the footer. I'm not familiar with VBA code, but I found the code below online and modified it a bit in an attempt to center the headers on each worksheet. Open the Excel spreadsheet where you want to define your column headings. You will see the Header and Footer dialog box, and a header box should appear at the top of the current page. (This box is also useful when you want headers and footers on every page except the first. Add formatted text to the headers or footers. I'm producing a report where each page in page layout view (set at letter size for ease of printing) is a different metric. What's the solution to creating different headers? A. Overview: A few tips for getting the column headings to display at the top of each page of a SQL Server Reporting Services (SSRS) report. Useful for changing page number styles in appellate briefs or for having distinct headers and footers in different parts of a document. I will show just one situation, where the pages are all below each other on the worksheet. [See also Excel, Outlook, PowerPoint, and Word "subheaders" at byte offset 512 (0x200). Used to make aggregated data stand out. Note: The Print Titles command will appear dimmed if you are working in cell On the Sheet tab, under Print titles , do one or. To add a horizontal-line we first need to create an image of a horizontal line in your favorite imaging software. Using different headers and footer in the same Google document. To choose your header and footer layout, check the box: Different first page: Use different headers and footers on the first page of the document or section. By default, the headers or footers on odd and even pages are the same. Once you've created your watermark image the next step is to add the watermark to your worksheet header. Learn how to add a section break. To assign different page settings to different parts of your publication you will need to insert a section break. If necessary, move to the header or footer you want to change. Excel 2003 - Different Header for each page I have the same problem in Word, but understand now that you enter "Section Break" to achieve different header/footer on each pagebut Excel doesn't give you that option. Re: VBA Code for Headers and Footers. If you want to get started coding in Excel, make sure to check out this chapter by chapter VBA tutorial. You may not realize it, but you can generate very customized headers and footers in Excel. Page Layout Tab; Expand the Menu option on the bottom right of the Page Set Up Group. If you're using Excel 2007, go to File, Page Setup and then open the last tab. You can create different headers and footers for every Section in your document (see Working with headers and footers). My solution for creating a month of pages with a new date on each page required no special macros or page headers. Note: Excel uses codes in order to automatically update the header or footer as you change the workbook. Once done, close the header design tab. In this article, we will focus on showing you 3 ways to set different watermarks for different pages in your Word document. Here you can change the Header (and Footer) distance then click OK. When adding a watermark in the word file, by default, the watermark will appear on every page. The following steps show how to make the column headings behave as a fixed header row: Select the row below your column headings. Excel: Add a Page Break at Each Change in Customer This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. Check the "Different first page" box if you just want a different header or footer on the first page. I want to put the same header and footer format on each page, but insert different header and footer text for each page. These are the steps. You can add headers and footers that appear on every page, or hide headers or footers on the first page of a document. You can refer to the below image. Import a list of known contacts If you plan to use email to keep in touch with existing customers, then your email list can be built largely by importing your existing customers details. For example, the place of the numbering of pages can be different on an even page that on an odd page. To add or edit a header or footer, click the left, center, or right header. You can easily adjust the page margins in a Word document by click on the Page Layout tab and then click Margins in the Page Setup group. To display the same page number on side-by-side pages On the Page Setup tab, click the arrow at the bottom of the Page Setup group. Formatting an Excel Worksheet for Printing 1. There’s a key concept discussed at this MSDN article: How to Display Row and Column Headers on Multiple Pages (Reporting Services). This will be shown in every subsequent page in your Word file. MS Word 2010: Create a different header for the first page This Word tutorial explains how to create a different header for the first page of a document in Word 2010 (with screenshots and step-by-step instructions). In the page set up, we have the ability to modify almost every piece of the page set up such as the margins of the page, the margins of the header and footer, the page orientation, the DPI (data per inch) of the output, the paper size, and pretty much. If you want to display the word Page as part of the page number, you will need to type Page at the desired location in the header. This is article explains, How to change "page headers' for different pages in MS Word. Adjust the Header/Footer Margins in Word These instructions are for Word 2007 or 2010 but can also be performed in earlier versions. This page describes how to use the autofilter in current versions of Excel (2007 and later). Headers and footers are lines of text that print at the top and bottom of each page. If you check both, you will have (in order, assuming your section begins on an odd page) a First Page Header/Footer, an Even Page Header/Footer, and an Odd Page Header/Footer. You can have only one Header and one Footer in each Worksheet, although you can have. To make it easier to edit header and footer content, click the Zoom pop-up menu in the toolbar and choose a zoom. In earlier versions of Word, from the View menu, select Header and Footer. The icon indicates that the content is related to VBA. Open the drop list on the Header text box and scroll it to see the pre-defined headers. Contiguous, uninterrupted data tables are much easier to work with,. Repeat Microsoft Word table headings across multiple pages.