How do I reorder sheets in excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dr Alok Modi MD - 15 May 2008 05:26 GMT

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

Reply to this Message

MartinW - 15 May 2008 08:13 GMT

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

>I have created some 15 sheets in an excel 2007 workbook. My problem is that
>I
[quoted text clipped - 9 lines]
>
> Dr Alok Modi MD

Reply to this Message

Dr Alok Modi MD - 15 May 2008 11:52 GMT

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

> Hi Alok,
>
[quoted text clipped - 21 lines]
> >
> > Dr Alok Modi MD

Reply to this Message

Spiky - 15 May 2008 18:41 GMT

On May 15, 5:52 am, Dr Alok Modi MD
<DrAlokMod...@discussions.microsoft.com> wrote:

> Thanks Martin
>
[quoted text clipped - 30 lines]
>
> > > 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.

Reply to this Message

MartinW - 15 May 2008 23:51 GMT

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

> Thanks Martin
>
[quoted text clipped - 33 lines]
>> >
>> > Dr Alok Modi MD

Reply to this Message

Dr Alok Modi MD - 16 May 2008 03:21 GMT

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

> My apologies Alok,
>
[quoted text clipped - 49 lines]
> >> >
> >> > Dr Alok Modi MD

Reply to this Message