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?
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?
Left click on the sheet you want to move, and drag it to the position you want it to be at.
Is there a point I should be clicking on?
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.
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.
This moves the page break up and down but how do I make page 5 page 3?
https://www.ablebits.com/office-addi...-page-numbers/
https://support.office.com/en-us/art...c-e873394a3b8b
https://support.office.com/en-us/art...692db4837e#bm4
Hopefully something above will help you.
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!
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/
Glad you got it.
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks