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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
my sheets are not in the order I want them. How do I change the order. The
data is already in the sheets.
Click to expand...
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 said:
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
Click to expand...

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
 
Back
Top