Page numbering in Excel does not start from 1
Excel does not split separate pages like in Word, but when printed, they will need to be broken down into individual pages. And you can also number the page for Excel like Word, can optionally number the page from one or the page number in Excel does not start from 1. That is the content mentioned in this article of TipsMake. vn .
To page numbering in Excel not starting from 1 we need to follow these steps:
Step 1: Go to the ribbon Page Layout on the toolbar.
Then click on the expand button of the Page Setup item in this ribbon.
Step 2: The Page Setup function window box will pop up. Here you can see the First page number section . Please enter the number you want to start numbering in Excel.
As in the example, TipsMake wants to number the page starting at 2, so it will fill 2 in the First page number .
Then remember to press OK to confirm the installation.
Step 3: Open the ribbon View on the toolbar, then switch the Excel view from Normal to Page Layout . With this view you can see the data in Excel as individual pages when printing.
Step 4: Click on Header or Footer of Excel file. This position will be the position to insert the page number when the data is printed. When you click on one of those six positions, the toolbar interface will automatically switch to the Header & Footer ribbon .
Step 5: Click the Page Number icon located in the Header & Footer Elements section of this ribbon. And & [Page] will be inserted in the location of your choice, this is a variable field used to number the page for your data.
When you click to another location of Excel data you will see the number of pages typed in the correct position and the first page will start with the number you have installed.
Thank you for reading our article on how to number numbers in Excel without starting from 1. Hopefully TipsMake.com 's article has comprehensive instructions on how to do it successfully. This technique for your data pages.
You should read it
- Page numbering in Excel does not start with number 1
- Page numbering method of type 1/2 in Excel
- Page numbering steps in Microsoft Word Microsoft
- How to number pages in Word 2007
- How to type pages in Word 2010
- How to number pages in all versions Excel (update 2020)
- How to insert page numbers in Excel
- Page numbering in Powerpoint
- Number pages in Word 2003, insert special characters, date and time into Word
- How to number pages on Word 2013
- Word 2013 Complete Guide (Part 14): Page title, footer and page numbering
- Numbering in Excel 2016
Maybe you are interested
How to print multiple pages on one sheet of paper in Word 2010, 2013
How to Auto Scroll Webpages on Safari - Automatically Up and Down
Beautiful Free Coloring Pages on Slidesgo
5 Ways to Fix 'Can't Reach This Page' Error on Microsoft Edge
Excel 2016 - Lesson 12: Formatting pages and printing spreadsheets in Excel
How to take a screenshot of the entire web page on Microsoft Edge