d2jsp
Log InRegister
d2jsp Forums > d2jsp > General Help > General Help Archive > Need Help With Excel
Add Reply New Topic New Poll
Member
Posts: 57
Joined: Aug 4 2011
Gold: 0.00
Aug 4 2011 03:00pm
Is there any chance to re-order the sheets in alphabetical order from an Excel document?
Not sure but i think there is an option, but dont remember which one.
Thank you for help.
Member
Posts: 211
Joined: Aug 3 2011
Gold: 289.00
Aug 4 2011 04:37pm
You can select and drag them each specifically. This can be time consuming if you have a lot of sheets. Right click which sheet you want to move, click on Copy or Move sheet and then specify where you would like to order it. I believe it is on a per-sheet basis. Sorry wish I could be more help.
Member
Posts: 57
Joined: Aug 4 2011
Gold: 0.00
Aug 5 2011 02:51pm
Quote (davids021 @ Aug 5 2011 01:37am)
You can select and drag them each specifically. This can be time consuming if you have a lot of sheets. Right click which sheet you want to move, click on Copy or Move sheet and then specify where you would like to order it. I believe it is on a per-sheet basis. Sorry wish I could be more help.


It will take too much time to move them manually since i have a lot of sheets.
Thank you for your time answering this question.
Member
Posts: 24,457
Joined: Mar 20 2008
Gold: 21,816.40
Aug 5 2011 03:02pm
highlight the cells, right click -> sort> arrange a-z

off the top of my head atleast, i know u have to highlight and right click (well quickest access)

This post was edited by Skibum on Aug 5 2011 03:03pm
Member
Posts: 57
Joined: Aug 4 2011
Gold: 0.00
Aug 6 2011 12:53pm
Quote (Skibum @ Aug 6 2011 12:02am)
highlight the cells, right click -> sort> arrange a-z

off the top of my head atleast, i know u have to highlight and right click (well quickest access)


I have selected all sheets and try t do the alphabetical sort, but when i do right click it deselect all sheets.
Go Back To General Help Archive Topic List
Add Reply New Topic New Poll