How can I add a worksheet in an Excel work book to the right of the last sheet?
In Excel work book there are 3 (default) worksheets-sheet1, sheet2 and sheet3. I would like to add sheet4 to the right hand side of sheet3. When I highlight sheet3 and add a worksheet, sheet4 is added between sheet2 and sheet3.(Order–sheet1, sheet2, sheet4, sheet3). Whereas what I want is sheet1, sheet2, sheet3, sheet4. Please help.
Thank you dear Coolsaint. You helped me. I dragged. Sheets are dragable.
right click next to the worksheet tab, add worksheet, im just guessing, have no excel in this pc …
June 20th, 2009 at 4:06 pm
right click next to the worksheet tab, add worksheet, im just guessing, have no excel in this pc …
References :
June 20th, 2009 at 4:12 pm
Drag the sheet4 to the right using your mouse and drop it after seet3.
The excel sheets are draggable.
References :
June 20th, 2009 at 4:40 pm
Allow the sheet to insert where it wants. Then right click on the tab of the new sheet, choose "Move or Copy", choose "Move to End" in the Before Sheet box. Click OK.
References :
June 20th, 2009 at 5:19 pm
Click and drag sheet 4 (by holding the mouse button down and moving it over to the right) where you'd prefer it to be.
References :
June 20th, 2009 at 5:31 pm
1. right click sheet 4
2. drag ro the right
3. drop after sheet 3
4. viola! finish
References :