How to insert page numbers in Excel
The operation of numbering Word pages in order from the first page, or inserting Word page numbers from any page is a basic and familiar requirement for those who work in the office. Excel also supports users to insert page numbers, but the implementation is completely different on Word .
With statistics, research or documents divided by different sections, you also need to type the page number for Excel as you work on Word. However, in Excel there will be no Page Number option like in Word to insert the page number, but you will have to use the Page Setup group to create the page number for Excel. The following article guides you how to insert page numbers in Excel.
- How to create Header in Microsoft Excel
- Inserting letters, logos sink into Microsoft Excel 2013
- How to insert text into images in Excel
How to write page numbers in Excel
Step 1:
In the Excel interface, click on the Page Layout tab and then click on the arrow on the right corner in this setting group.
Step 2:
The Page Setup dialog box appears, click the Header / Footer tab . Here the user can choose to insert the Excel page number at the top of the page, by clicking on the Custome Header. If you want to insert at the bottom of the page, click Customer Footer. Here I choose to insert it at the bottom of the footer so click Customer Footer .
Step 3:
The Footer dialog box appears. You will have 3 positions to place the page number including Left section (left), Center section (center), Right section (right). If you want to set the position of the page, place the cursor there and click on the Insert Page Number icon as shown below.
Step 4:
Immediately appear & [Page] in the location we selected earlier, click OK to finish.
Step 5:
Click OK to close the Page Setup interface. Now to check if the page number has been inserted into Excel, click on the Office icon on the interface and select Print> Print Preview .
Users will see the page number appearing in the document interface.
So you can insert the page number in Excel already. There is no built-in Page Number feature on Excel, but you need to create the page number by customizing the Page Setup page in Excel. This is similar to creating a Haeder or Footer for Excel, but we will click on the letter A to enter the content.
Video tutorial to insert page numbers in Excel
See also: How to repeat titles in Excel 2007, 2010 and 2013 when printing.
I wish you all success!
You should read it
- How to number Excel pages from any number
- Instructions to stamp negative numbers in Excel
- Page numbering in Excel does not start with number 1
- How to print Excel on an A4 page
- How to insert a Word document into an Excel file
- How to Insert Headlines in Excel
- How to add page numbers on Google Docs
- How to number pages in all versions Excel (update 2020)
May be interested
- Page numbering in Wordword numbering in word 2019 is similar to that when you page numbers in word 2010 or word 2007 and below.
- How to Insert Page Numbers in Wordmicrosoft word is a commonly used word processor, if not the most popular computer writing software on the planet. in order to get the most out of it, however, you must be able to navigate increasingly complex menus and screens. luckily,...
- How to Insert a Page Break in an Excel Worksheetif you've ever tried printing a large microsoft excel worksheet, you've undoubtedly encountered some awkward-looking print jobs. excel's automatic page breaks don't exactly take your custom data views into consideration. in order to...
- How to insert a Word document into an Excel fileto be able to open word text files right in excel file, we can use the built-in feature to allow inserting data right on excel.
- PI (PI Function) in Excel - How to use PI numbers in Excelpi (pi function) in excel - how to use pi numbers in excel. pi number is a mathematical constant with an approximate value of 3,1415926535897 ... we can find pi numbers in many trigonometric and geometric formulas. especially the formulas related to circles, ellipses, and spheres:
- Split numbers from strings in Excelin the process of working with excel, i have encountered some cases that require separating only the fraction in a given string, now this post shares with you how to do this. the following article details how to separate numbers from a given string in excel.
- How to insert watermark, logo sink into Excelinserting a logo into an excel file will help stamp documents, avoid copying content.
- How to insert a batch image into Excel boxto insert images into cells in excel, you have many different ways to perform them, manually or using formulas.
- How to Insert Headlines in Excelthere are many ways to create titles in excel depending on different purposes. you can freeze a row so that it stays on the screen even if the reader scrolls down. if you want the title to appear on multiple pages, you can set up rows and columns to print on each page. if the data is organized into a table, you can use headers to filter the data.
- Instructions for inserting a PDF file into Excel spreadsheetif you're having trouble inserting a pdf file into an excel spreadsheet and you don't know how to do it. inserting pdf files into excel spreadsheets is not as simple as you think. in the article below, network administrator will guide you through the steps to insert a pdf file into excel spreadsheet.