how do I sort tabs on an excel spreadsheet

P

Percy

All invoices are allocated a job number of which I have a different tab.

Is there a way I can sort these tabs into numerical order
 
M

Mike G

I know you can manualy move them to the order you want. Hold down left
mouse button while over the tab and move.
 
P

Percy

Thank you Mike - the trouble is I have so many tabs and each time I open one
they all move around again.
 
J

Jim Cone

Percy,
The free Excel add-in "XL Extras" will sort sheets for you.
(just right click on a sheet tab and select sort sheets)
It can do other nice stuff including creating a table of contents sheet.
Download from... http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA



"Percy" <Percy @discussions.microsoft.com>
wrote in message
All invoices are allocated a job number of which I have a different tab.

Is there a way I can sort these tabs into numerical order
 
Top