#HOW TO SHOW HEADER IN EXCEL 2013 HOW TO#
Click here and learn how to make it much simpler for your readers to identify cells when reading your data on pieces of paper. Click the OK button at the bottom of the window when you are done.Īnother helpful setting to use in Excel 2013 when you are concerned about printing a spreadsheet is to repeat the top header row on every page. I wondered if perhaps the new and improved Excel 2013 had a way to do that, before I go deleting the header and footer information from 48 different places and attempt to place it in amongst the data. You can then click the Header tab at the top of this window and enter the information that you want to appear at the top of the rest of the pages. They want to open the Excel spreadsheet during a presentation and manipulate the cells in front of everyone and still keep the title in view. Step 7: Enter the contents of your first page header. Step 6: Click the First Page Header tab at the top of this window. Step 5: Check the box to the left of Different first page, then click the Custom Header button. If the data is not in an Excel Table, Excel converts it into an Excel Table first.
#HOW TO SHOW HEADER IN EXCEL 2013 INSTALL#
Excel 20 users should download and install the Power Query as an add-in.
Step 4: Click the Header/Footer tab at the top of the Page Setup window. Occasionally Excel will display a preview. Step 3: Click the tiny Page Setup dialog launcher at the bottom-right corner of the Page Setup section of the ribbon. Step 2: Click the Page Layout tab at the top of the window. You will be able to customize the header that only appears on the first page, then you will be able to use a different header for the rest of the pages. The steps in the tutorial below are going to show you how to use two different headers for your Excel 2013 worksheet. Using a Different Header on the First Page in Excel 2013 Our guide below will show you how to specify a header that is different on the first page. But occasionally you might need to put different information on the first page of the spreadsheet that what will appear on every page after the first.Įxcel 2013 offers a formatting option that makes this possible, and you won’t even need to create and link multiple sections of a document. You can even put a picture in a header or footer.
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.
0 kommentar(er)
