![]() If you are printing a report which is a continuation of some other report, or which is a part of some the overall report, you may want to begin page numbers with a different number (instead of 1). Start Page Numbering with the Desired Number If you want to insert page numbers in multiple worksheets, select all the worksheets (hold the SHIFT key and select the worksheet tabs) and then follow the above steps. If you want to insert page numbers in on the active worksheet only, follow the above steps. This will instantly insert page numbers in Excel. ![]() You will see the output format right below the drop-down. In the Footer drop-down, select of ? option.In the Page Setup dialogue box, select the Header/Footer tab.This will open the Page Set dialogue box.Within the Page Setup Group, click on the dialogue launcher. You can also insert page numbers in Excel using the page setup dialogue box. Insert Page Numbers in Excel: Page Setup Dialogue Box Similarly, enter the page number format on even pages, or leave it blank if you don’t want page numbers on even pages. Enter the format in which you want the page numbers on odd pages. Now when you click on the box on odd pages, in the bottom left, it would show Odd Page Footer.Go to Design –> Options and check Different Odd and Even Pages.Click on the box where you want to insert the page number.Scroll down and select the footer where you want to insert the page numbers in Excel.Go to View and select Page Layout view.If you want to have different page numbers for odd and even pages, you can easily do this using the inbuilt settings.įor example, you may not want to show page numbers on even pages. Now, whatever you have entered in the first page would only be visible on the first page and rest all the pages would show page numbers. Let’s say, I want to show my website name in this case. Enter the text that you want to display on the first page only.With the box selected, go to Design –> Options and check the Different First Page option.While in the Page Layout view, select the footer box in the first page where you want to insert the text.For example, on the first page, you may want to have Company’s name/website or copyright info along with the page number. You may want to have a different text in the footer on the first page, and regular page numbers of other pages. ![]() If you print the worksheet, the page numbers also get printed. You would not see it when you go back to the normal view. Note that these page numbers are visible only in the Page Layout view. Now the page numbers would be visible at the bottom of each page.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |