How To Change The Page Numbering Order In An Excel Spreadsheet?

Many times, and Excel Spreadsheet doesn’t fit on one page because it is too large. Cells are pushed to another page, and depending how we have organized our data, we sometimes need to change the order of the pages manually so it could be easier for the viewer. Sometimes additional Columns will be printed at the end of the Sheet, after all the Rows have been printed and many other issues also occur. If you want to change the order of our Pages in our Excel Spreadsheet just keep on reading.

How To Change The Page Order in Excel

In the following image, we can see the order of the Page Breaks that we have in our Spreadsheet. We can see Page 1, beneath it we see Page 2 and it goes on until Page 7. Then it starts again from the top middle section with the numbering Page 8, Page 9 and goes on until Page 14. Once again it starts from the top right section with the Numbering Page 15, Page 16 and goes on until Page 21. In order for us to change the Order of the Pages in our Spreadsheet, we must select the Page Layout tab and then locate the area of the ribbon named Page Setup. Once we locate the Page Setup area, at the bottom right corner we select the arrow that is located it there, where we can check out all the Page Formatting Options that we have. Keep in mind, that for use to see the Page Numbering, we must select the View tab, and then from the area of the ribbon named Workbook Views, to select the command Page Break Preview.

Page Layout Tab - Page Setup Area

Once we select the arrow at the bottom right corner of the Page Setup area, the Page Setup dialog box appears as shown in the image below. The Page Setup dialog box is separated by four (4) tabs, which are the following: Page, Margins, Header/Footer and Sheet. For this post, we must activate the Sheet tab by clicking on it.

Page Setup Dialog Box - Sheet Tab

The Sheet tab of the Page Setup dialog box is separated by different areas. For us to change the Order of the Pages, we must locate the area Page Order which is at the bottom of the dialog box as shown in the image below.

Under the Page Order area are the following two commands where we can activate or deactivate, and which are the following:

  • Down, Then Over: It is activated by default, and if we leave it as it is the Numbering of our Pages in our Spreadsheet will be as in the example above.
  • Over, Then Down: If we activate this command, by clicking on the check button at the left of the command, the Numbering of our Pages in our Spreadsheet will change.

Page Order

In the next image, I have activated the command Over, Then Down and then I pressed the Ok button to return to my Spreadsheet. Now, we can see how the Numbering of the Pages in the Spreadsheet have changed. The Numbering goes from the Top till the end, and then goes Down and starts all over again.

Preview of Page Order

So, if anyone want to change the order of the Page Numbering in an Excel Spreadsheet, the procedure is quite easy.

Below you can check out the video that describes, How To Change The Page Numbering In An Excel Spreadsheet.

Don’t Forget To Subscribe To My YouTube Channel.

YouTube Channel

Advertisements

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on April 1, 2019, in Excel 365 English, Microsoft Office 365 ProPlus English and tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on How To Change The Page Numbering Order In An Excel Spreadsheet?.

Comments are closed.