HOW DO I CHANGE THE ORDER OF THE SHEETS IN EXCEL WORKBOOK?
 

my sheets are not in the order I want them. How do I change the order. The
data is already in the sheets.

Click on the tab and drag it to where you want to.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------

"joanbaer" wrote in message
...
my sheets are not in the order I want them. How do I change the order.
The
data is already in the sheets.

joanbaer wrote:
my sheets are not in the order I want them. How do I change the order. The
data is already in the sheets.
Select the cells you want to sort then go to data sort a window pops up
and you can chose up to 3 sorts.
The help files are really pretty good a search on "sort" without the quotes
will get you more info.

gls858

gls858 wrote:
joanbaer wrote:

my sheets are not in the order I want them. How do I change the
order. The data is already in the sheets.

Select the cells you want to sort then go to data sort a window pops up
and you can chose up to 3 sorts.
The help files are really pretty good a search on "sort" without the quotes
will get you more info.

gls858

Sorry I misread that I thought you wanted to sort the data. Gotta read a
little slower next time. Ken gave you the correct answer.

gls858

Or, to sort them alphabetically ...

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


--
Regards,
Zack Barresse, aka firefytr


"joanbaer" wrote in message
...
my sheets are not in the order I want them. How do I change the order.
The
data is already in the sheets.