How do I reorder sheets in excel

[Dr Alok Modi MD]

I have created some 15 sheets in an excel 2007 workbook. My problem is that I
went on creating the sheets , one for each one of my employees, as & when i
needed to, but now searching for them whenever I want a particular employee
sheet is very timeconsuming. Is there anty way I can rearrange the sheets as
per their alphabetical order ?

Sincerely


Dr Alok Modi MD

 

[MartinW]

Hi Alok,

You can Click and drag each tab to wherever you
want, a little arrow will show up where the sheet is
going to be dropped.

You can also right click on a tab and go to
sort sheets.

HTH
Martin

 

[Dr Alok Modi MD]

Thanks Martin

I could do the dragging the tab. But it is cumbersome if it there are some
50 sheets or so. Also the right click method does not show any sort sheet
function in excel 2007.
Pl help me

Dr Alok Modi MD

 

[Spiky]

Thanks Martin

I could do the dragging the tab. But it is cumbersome if it there are some
50 sheets or so. Also the right click method does not show any sort sheet
function in excel 2007.
Pl help me

Dr Alok Modi MD

I've never seen Excel have Sort Sheets. Unless version 2007 has added
something, I don't think there is a way to do this.

You can search through multiple sheets. You could Select All sheets,
then do a Find for the employee name. Assuming the name is actually in
a cell on the proper sheet. But then you have to Deselect the other
sheets if you have any data to enter, since you don't want to type the
same thing on every sheet, presumably.

 

[MartinW]

My apologies Alok,

The sort files option is part of an Addin that I have installed.
I find that with add-ins, after a while, you get so familiar with the
functionality you forget they are extras.

If you want the add-in you can find it at Jim Cone's site here
http://www.realezsites.com/bus/primitivesoftware/products.php
Scroll down the page and look for XL Extras.

It used to be free, but now it looks like Jim is charging a small
fee, $9, which is still not much to pay.

HTH
Martin

 

[Dr Alok Modi MD]

Thanks Martin. I saw the add-in illustration that comes with the .doc file
and it is useful. But yesterday, i got down to right click each tab and
"move" the tab before the one I wanted in an alphabetical order, so my work
has already been done, though it took me some 20 minutes. But thanks for
this. I'll remember it.

Sincerely

Alok