(Note that headers are visible only in Page Layout view, the Print Preview window in Backstage view ( File tab, Print), and the printed worksheet. To return to the Normal view–the way you typically work in Excel–click the Normal button on the status bar at the bottom right of your screen. When you’re viewing it, you’ll be in Page Layout view. You’ll see that your worksheet header contains the word “Picture.” To view the actual watermark, just click in any cell in your worksheet. PNG file on your computer and add it to the header. Find your copy of the DRAFT or CONFIDENTIAL. Excel switches to Page Layout view, and your cursor appears in the center header box at the top of the worksheet page (under Header).Ĭlick the Design tab, and in the Header & Footer elements group, click Picture. Click and select the row you wish to appear at the top of every page. Under the Sheet tab, in the 'Rows to repeat at top' field, click the spreadsheet icon. In your worksheet, click the Insert Tab and in the Text group, click Header & Footer. Click the Page Layout tab > In the 'Page Setup' group, click Print Titles. Specify the location where you want to save the picture and do so. Right-click on DRAFT or CONFIDENTIAL, and on the shortcut menu, click Save Target As. Just follow the steps below the graphic.įirst you’ll need to open and save the watermarks we’ve created. You need to change the insert to specify that it is embedded: Insert(Filename: (Hover over the various table styles to see a live preview.) In this method, you can use the Insert tab to insert the Excel spreadsheet data into a Word document. Choose a style/color option that appeals to you.Click the "Design" tab > Locate the "Table Styles" group.Click on a cell in the table to activate the "Table Tools" tab.Resize your columns to make the headings visible.Verify that the range is correct > Click.If you have column headings, check the box "My table has headers".Click the "Insert" tab > Locate the "Tables" group.Use your mouse to select the cells that contain the information for the table.Then click the left, center, or right box at the top of the worksheet of page 1 to add. Click Insert > Header & Footer, and then under the Design tab, check Different First Page option, see screenshot: 3. Activate your worksheet that you want to use. This page will show you how to convert Excel data into a table. To just insert the header or footer to the first page in a worksheet, please do as this: 1.#HOW TO INSERT A HEADER IN EXCEL ON A MAC HOW TO#