Therefore, in the Print Preview pane, you can see page number as of 3 on top of Sheet-1.įurthermore, you can see page number as of 3 on top of Sheet-2. Next, keep holding the SHIFT key, and go to the File tab.Here, we selected of? as our page number style.Īfterward, you can see Page # of 1 in the center of the page.Then, you can see several page number styles appear. Furthermore, click on the Header option from the Header & Footer group.Furthermore, we click on the center section as we want our page number on the top and center positions of the sheet.You will see three sections under the Header title. Then, hover your mouse on top of your sheet.Afterward, from Text group > select Header & Footer.However, if you want to select multiple nonadjacent sheets from the sheet tab, press and hold the CTRL key. Here, you must press and hold the SHIFT key to select adjacent sheets from the sheet tab. Here, you must keep holding the SHIFT key until you go to the Print Preview pane to see the preview of the page number. First, we will click on Sheet-1, press and hold the SHIFT key, and select Sheet-2 and Sheet-3.In this method, we will use the Header & Footer option to Insert Page Number Across Worksheets. Here, we have three worksheets named Sheet-1, Shee-2, and Sheet-3. Read More: How to Insert Page Number in Excel (7 Easy Methods) After that, click on the rightward arrow to see the page number of 3rd worksheet.įinally, you can see page number 3 on top of Sheet 3.Next, you can see page number 2 on top of Sheet 2. Next, click on the rightward arrow to see the page number of other worksheets.However, if you want to select multiple nonadjacent sheets from the sheet tab, press and hold the CTRL key.Īfterward, in the Print Preview pane, you can see page number 1 on top of Sheet 1. One thing that must be noted here is you must press and hold the SHIFT key to select adjacent sheets from the sheet tab. Then, select Sheet 1, press and hold the SHIFT key, and select Sheet 2 and Sheet 3.At this point, repeat the following steps to insert the page number in Sheet 2 and Sheet 3 as well.Later, in the Page Setup dialog box, you can see 1 in the Header box, indicating the starting page number. This & indicates that the page number will be inserted in the center section of the page. Moreover, we click on the Insert Page Number box which is marked with a red color.Īs a result, you can see in the center section, & appears. Afterward, we click on the Center section as we want the page number in the center of the page.Here, you can see the Left section, Center section, and Right section. Here, we selected Custom Header as we want the page number on top of the page.Then, you can see Custom Header and Custom Footer options. Furthermore, go to the Header/Footer group.After that, from the Page Setup group > selec t Page Setup drop-down arrow which is marked with a red color box.Īt this point, a Page Setup dialog box will appear.First of all, from Sheet 1 of our Excel file > go to the Page Layout tab. Let’s go through the following steps to do the task. In this method, we will use the Page Layout tab to Insert Page Number Across Worksheets. Here, we have three worksheets named Sheet 1, Sheet 2, and Sheet 3. Using Page Layout Tab to Insert Page Number Across Worksheets You can use any available Excel version.ġ. To do the task, we will show to you 3 easy and effective methods. We want to print the worksheets, so we need to insert sequential page numbers across the worksheets. You can see the following Excel file has several Worksheets. 3 Methods to Insert Sequential Page Numbers Across Worksheets
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |