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

[joanbaer]

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

 

[Ken Wright]

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
------------------------------­------------------------------­----------------

 

[gls858]

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]

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

 

[Zack Barresse]

Or, to sort them alphabetically ...

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