+ Reply to Thread
Results 1 to 10 of 10

Move Page order

  1. #1
    Registered User
    Join Date
    10-15-2014
    Location
    USA
    MS-Off Ver
    Office 2007
    Posts
    5

    Move Page order

    Hello Everyone,

    I have a Excel 2017 I am tring to change the order of the pages. I would like to make the last page the third page. Any ideas?

  2. #2
    Registered User
    Join Date
    07-14-2013
    Location
    USA
    MS-Off Ver
    MS 365
    Posts
    97

    Re: Move Page order

    Left click on the sheet you want to move, and drag it to the position you want it to be at.

  3. #3
    Registered User
    Join Date
    10-15-2014
    Location
    USA
    MS-Off Ver
    Office 2007
    Posts
    5

    Re: Move Page order

    Is there a point I should be clicking on?

  4. #4
    Registered User
    Join Date
    10-15-2014
    Location
    USA
    MS-Off Ver
    Office 2007
    Posts
    5

    Re: Move Page order

    Oh I see you think I want to move the sheet, I dont want to move the sheet I want to move a page within the sheet.

  5. #5
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,012

    Re: Move Page order

    https://support.office.com/en-us/art...640612bdc2#bm3



    Move a page break

    IMPORTANT: To enable dragging of page breaks to another location in a worksheet, make sure that the cell drag-and-drop feature is enabled. If this feature is not enabled, you may not be able to move any page breaks.

    To verify that drag-and-drop is enabled, do the following:

    Click the Microsoft Office Button Office button image , and then click Excel Options.

    In the Advanced category, under Editing options, select the Enable fill handle and cell drag-and-drop check box, and then click OK.

    Click the worksheet that you want to print.

    On the View tab, in the Workbook Views group, click Page Break Preview.

    You can also click Page Break Preview Button image on the status bar.

    To move a page break, drag the page break to a new location.

    NOTE: Moving an automatic page break changes it to a manual page break.

  6. #6
    Registered User
    Join Date
    10-15-2014
    Location
    USA
    MS-Off Ver
    Office 2007
    Posts
    5

    Re: Move Page order

    This moves the page break up and down but how do I make page 5 page 3?

  7. #7
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,012

  8. #8
    Registered User
    Join Date
    10-15-2014
    Location
    USA
    MS-Off Ver
    Office 2007
    Posts
    5

    Re: Move Page order

    Thanks Yes I got it, I guess I was thinking of this wrong, I made another page at the bottom and copied my last page so that I now had a extra page I them copied and pasted them in order thanks!

  9. #9
    Forum Contributor
    Join Date
    12-18-2016
    Location
    London
    MS-Off Ver
    Microsoft 2013
    Posts
    145

    Re: Move Page order

    Let’s refer to article in the following thread which discusses about a similar and see if it helps: https://www.howtogeek.com/162509/how...in-excel-2013/

  10. #10
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,012

    Re: Move Page order

    Glad you got it.

    Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. If spreadsheet goes beyond a page, how to move a value to the second page
    By cassera in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-15-2015, 04:07 AM
  2. move the order to next day once the limit is approached
    By sbo123 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-26-2014, 08:19 AM
  3. [SOLVED] I can't move my page breaks in Page Break Preview
    By btaft in forum Excel General
    Replies: 7
    Last Post: 05-14-2014, 09:53 AM
  4. How to copy a range on one page and list in order on another page?
    By jaedmar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2011, 06:04 PM
  5. Order Summary Page
    By odie2828 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-03-2008, 04:39 AM
  6. [SOLVED] [SOLVED] Move data line from end of page 1 to page 2
    By sweeta1974 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-19-2006, 09:45 AM
  7. [SOLVED] Cursor doesn't move when page up or page down in Excel 2003
    By christiandad in forum Excel General
    Replies: 3
    Last Post: 12-12-2005, 12:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1