Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default how do I sort tabs on an excel spreadsheet

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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,101
Default how do I sort tabs on an excel spreadsheet

Check out this solution

http://www.cpearson.com/excel/sortws.htm

Mike

"Percy" wrote:

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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 26
Default how do I sort tabs on an excel spreadsheet

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

"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



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default how do I sort tabs on an excel spreadsheet

Thank you Mike - but a bit too difficult for me to take in and action

"Mike" wrote:

Check out this solution

http://www.cpearson.com/excel/sortws.htm

Mike

"Percy" wrote:

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

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default how do I sort tabs on an excel spreadsheet

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

"Mike G" wrote:

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

"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






  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,290
Default how do I sort tabs on an excel spreadsheet


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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I sort tabs on an existing spreadsheet? IRISHBABE Excel Worksheet Functions 2 December 19th 06 02:06 AM
how many tabs on a excel spreadsheet can you have? Deabug Excel Worksheet Functions 2 August 23rd 06 09:53 PM
How do I add tabs at the bottom of the excel spreadsheet? The Professor Excel Discussion (Misc queries) 2 August 13th 06 03:33 AM
sort sheet tabs in Excel JOJO Excel Worksheet Functions 2 May 19th 05 04:36 AM
Can I sort Excel sheet tabs alphabetically? Governors Club Excel Discussion (Misc queries) 1 February 25th 05 07:56 PM


All times are GMT +1. The time now is 09:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"