PC Review


Reply
Thread Tools Rate Thread

Can the worksheets in a work book be sorted ascending?

 
 
=?Utf-8?B?Sm8xMjM=?=
Guest
Posts: n/a
 
      26th Jun 2007
Any help I can get with this question would be greatly appreciated.

 
Reply With Quote
 
 
 
 
Chip Pearson
Guest
Posts: n/a
 
      26th Jun 2007
Excel does not provide a built in way to do this. You can use the code at
www.cpearson.com/excel/sortws.htm to sort some or all of the worksheet tabs
in either ascending or descending order.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Jo123" <(E-Mail Removed)> wrote in message
news:A9792FF5-F4B4-4C8D-96E7-(E-Mail Removed)...
> Any help I can get with this question would be greatly appreciated.
>


 
Reply With Quote
 
Meebers
Guest
Posts: n/a
 
      26th Jun 2007
With the left mouse button, you can pick up the tabs and move them where you
want them.
"Jo123" <(E-Mail Removed)> wrote in message
news:A9792FF5-F4B4-4C8D-96E7-(E-Mail Removed)...
> Any help I can get with this question would be greatly appreciated.
>



 
Reply With Quote
 
Vasant Nanavati
Guest
Posts: n/a
 
      26th Jun 2007
Are you saying you want new sheets to be added to the right rather then to
the left? Or do you just want to sort existing worksheets?

________________________________________________________________________

"Jo123" <(E-Mail Removed)> wrote in message
news:A9792FF5-F4B4-4C8D-96E7-(E-Mail Removed)...
> Any help I can get with this question would be greatly appreciated.
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How Do I Tie Worksheets to one Work book? Bettine S Cavanaugh Microsoft Excel Worksheet Functions 2 31st Mar 2008 04:01 AM
Why must the table for Vlookup be sorted in ascending order? Epinn Microsoft Excel New Users 3 12th Aug 2006 08:04 AM
group by field but not sorted ascending or descending =?Utf-8?B?RGFuIE0=?= Microsoft Access Reports 8 5th Jan 2006 05:32 PM
List of Worksheets in a work book Bottle Microsoft Excel Worksheet Functions 2 8th Dec 2004 12:17 PM
How can I sort worksheets in a work book? =?Utf-8?B?UGF1bEdlZQ==?= Microsoft Excel Worksheet Functions 1 29th Sep 2004 03:28 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:45 PM.