Hello to all.Hope everybody are doing great.
I have a question in Excel 2003.How can I insert another sheet just next to
the old sheet? for example I have sheet1 sheet 2 sheet 3 I want to insert
sheet 4 to the right of the sheet 3? How can I? because when I do this the
sheet will place to the left.Please help me.
I'm waiting for you.Thanks.

Hi Tara,

Regardless of where you insert the sheet, you can move sheet
tabs by simple click and drag on the tab. As you drag, a broad arrow
will show where it will be dropped once you let go of the
left button.

HTH
Martin


"Tara" wrote in message
...
Hello to all.Hope everybody are doing great.
I have a question in Excel 2003.How can I insert another sheet just next
to
the old sheet? for example I have sheet1 sheet 2 sheet 3 I want to insert
sheet 4 to the right of the sheet 3? How can I? because when I do this the
sheet will place to the left.Please help me.
I'm waiting for you.Thanks.

Thank you so much Martin.
I Konw that by drag and drop I can move my new sheet, but my teacher has
asked me why when we insert new sheet it goes to the right for example sheet
1 2 4 3
How can I insert a new sheet into the right of my old sheet? Do you know?
Thanks again.

"MartinW" wrote:

Hi Tara,

Regardless of where you insert the sheet, you can move sheet
tabs by simple click and drag on the tab. As you drag, a broad arrow
will show where it will be dropped once you let go of the
left button.

HTH
Martin


"Tara" wrote in message
...
Hello to all.Hope everybody are doing great.
I have a question in Excel 2003.How can I insert another sheet just next
to
the old sheet? for example I have sheet1 sheet 2 sheet 3 I want to insert
sheet 4 to the right of the sheet 3? How can I? because when I do this the
sheet will place to the left.Please help me.
I'm waiting for you.Thanks.

That's just default behaviour, new columns are inserted to the
left of the active column, new rows are inserted above the active row
and new tabs are inserted to the left of the active tab.

HTH
Martin


"Tara" wrote in message
...
Thank you so much Martin.
I Konw that by drag and drop I can move my new sheet, but my teacher has
asked me why when we insert new sheet it goes to the right for example
sheet
1 2 4 3
How can I insert a new sheet into the right of my old sheet? Do you know?
Thanks again.

"MartinW" wrote:

Hi Tara,

Regardless of where you insert the sheet, you can move sheet
tabs by simple click and drag on the tab. As you drag, a broad arrow
will show where it will be dropped once you let go of the
left button.

HTH
Martin


"Tara" wrote in message
...
Hello to all.Hope everybody are doing great.
I have a question in Excel 2003.How can I insert another sheet just
next
to
the old sheet? for example I have sheet1 sheet 2 sheet 3 I want to
insert
sheet 4 to the right of the sheet 3? How can I? because when I do this
the
sheet will place to the left.Please help me.
I'm waiting for you.Thanks.

If you are looking for the REASON for this behaviour.

I think it would be so that Excel can maintain it's relative
references. Whilst everything is contained between the
top left of the worksheet and the active cell, then relative
references would remain relatively simple, but to step
outside those bounds would become extremely difficult.

HTH
Martin


"MartinW" wrote in message
...
That's just default behaviour, new columns are inserted to the
left of the active column, new rows are inserted above the active row
and new tabs are inserted to the left of the active tab.

HTH
Martin


"Tara" wrote in message
...
Thank you so much Martin.
I Konw that by drag and drop I can move my new sheet, but my teacher has
asked me why when we insert new sheet it goes to the right for example
sheet
1 2 4 3
How can I insert a new sheet into the right of my old sheet? Do you know?
Thanks again.

"MartinW" wrote:

Hi Tara,

Regardless of where you insert the sheet, you can move sheet
tabs by simple click and drag on the tab. As you drag, a broad arrow
will show where it will be dropped once you let go of the
left button.

HTH
Martin


"Tara" wrote in message
...
Hello to all.Hope everybody are doing great.
I have a question in Excel 2003.How can I insert another sheet just
next
to
the old sheet? for example I have sheet1 sheet 2 sheet 3 I want to
insert
sheet 4 to the right of the sheet 3? How can I? because when I do this
the
sheet will place to the left.Please help me.
I'm waiting for you.Thanks.

If you have Excel 2007, there is an insert sheet button at the right of the
sheet buttons. Prior to Excel 2007, you need VBA.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Tara" wrote in message
...
Thank you so much Martin.
I Konw that by drag and drop I can move my new sheet, but my teacher has
asked me why when we insert new sheet it goes to the right for example
sheet
1 2 4 3
How can I insert a new sheet into the right of my old sheet? Do you know?
Thanks again.

"MartinW" wrote:

Hi Tara,

Regardless of where you insert the sheet, you can move sheet
tabs by simple click and drag on the tab. As you drag, a broad arrow
will show where it will be dropped once you let go of the
left button.

HTH
Martin


"Tara" wrote in message
...
Hello to all.Hope everybody are doing great.
I have a question in Excel 2003.How can I insert another sheet just
next
to
the old sheet? for example I have sheet1 sheet 2 sheet 3 I want to
insert
sheet 4 to the right of the sheet 3? How can I? because when I do this
the
sheet will place to the left.Please help me.
I'm waiting for you.Thanks.

Assign one of these to a button or shortcut key.

Sub addafter()
Worksheets.Add After:=Worksheets(Worksheets.Count)
End Sub

Sub addafter2()
Worksheets.Add After:=ActiveSheet
End Sub


Gord Dibben MS Excel MVP

On Sat, 28 Jun 2008 06:08:01 -0700, Tara wrote:

Thank you so much Martin.
I Konw that by drag and drop I can move my new sheet, but my teacher has
asked me why when we insert new sheet it goes to the right for example sheet
1 2 4 3
How can I insert a new sheet into the right of my old sheet? Do you know?
Thanks again.

"MartinW" wrote:

Hi Tara,

Regardless of where you insert the sheet, you can move sheet
tabs by simple click and drag on the tab. As you drag, a broad arrow
will show where it will be dropped once you let go of the
left button.

HTH
Martin


"Tara" wrote in message
...
Hello to all.Hope everybody are doing great.
I have a question in Excel 2003.How can I insert another sheet just next
to
the old sheet? for example I have sheet1 sheet 2 sheet 3 I want to insert
sheet 4 to the right of the sheet 3? How can I? because when I do this the
sheet will place to the left.Please help me.
I'm waiting for you.Thanks.

Thanks Gord
But I don't know how to use them? could you explain it to me?what should I
do with them?Thanks a lot.

"Gord Dibben" wrote:

Assign one of these to a button or shortcut key.

Sub addafter()
Worksheets.Add After:=Worksheets(Worksheets.Count)
End Sub

Sub addafter2()
Worksheets.Add After:=ActiveSheet
End Sub


Gord Dibben MS Excel MVP

On Sat, 28 Jun 2008 06:08:01 -0700, Tara wrote:

Thank you so much Martin.
I Konw that by drag and drop I can move my new sheet, but my teacher has
asked me why when we insert new sheet it goes to the right for example sheet
1 2 4 3
How can I insert a new sheet into the right of my old sheet? Do you know?
Thanks again.

"MartinW" wrote:

Hi Tara,

Regardless of where you insert the sheet, you can move sheet
tabs by simple click and drag on the tab. As you drag, a broad arrow
will show where it will be dropped once you let go of the
left button.

HTH
Martin


"Tara" wrote in message
...
Hello to all.Hope everybody are doing great.
I have a question in Excel 2003.How can I insert another sheet just next
to
the old sheet? for example I have sheet1 sheet 2 sheet 3 I want to insert
sheet 4 to the right of the sheet 3? How can I? because when I do this the
sheet will place to the left.Please help me.
I'm waiting for you.Thanks.

See Dave's reply in addition this this one.

Another link for your perusal would be Ron de Bruin's site

Where to store code...............

http://www.rondebruin.nl/code.htm


Gord

On Sat, 28 Jun 2008 14:19:00 -0700, Tara wrote:

Thanks Gord
But I don't know how to use them? could you explain it to me?what should I
do with them?Thanks a lot.

"Gord Dibben" wrote:

Assign one of these to a button or shortcut key.

Sub addafter()
Worksheets.Add After:=Worksheets(Worksheets.Count)
End Sub

Sub addafter2()
Worksheets.Add After:=ActiveSheet
End Sub


Gord Dibben MS Excel MVP

On Sat, 28 Jun 2008 06:08:01 -0700, Tara wrote:

Thank you so much Martin.
I Konw that by drag and drop I can move my new sheet, but my teacher has
asked me why when we insert new sheet it goes to the right for example sheet
1 2 4 3
How can I insert a new sheet into the right of my old sheet? Do you know?
Thanks again.

"MartinW" wrote:

Hi Tara,

Regardless of where you insert the sheet, you can move sheet
tabs by simple click and drag on the tab. As you drag, a broad arrow
will show where it will be dropped once you let go of the
left button.

HTH
Martin


"Tara" wrote in message
...
Hello to all.Hope everybody are doing great.
I have a question in Excel 2003.How can I insert another sheet just next
to
the old sheet? for example I have sheet1 sheet 2 sheet 3 I want to insert
sheet 4 to the right of the sheet 3? How can I? because when I do this the
sheet will place to the left.Please help me.
I'm waiting for you.Thanks.

hi
You can do that by drag&draft. If it possible in Excel 2003.
hope this helps

nader

"Tara" wrote:

Hello to all.Hope everybody are doing great.
I have a question in Excel 2003.How can I insert another sheet just next to
the old sheet? for example I have sheet1 sheet 2 sheet 3 I want to insert
sheet 4 to the right of the sheet 3? How can I? because when I do this the
sheet will place to the left.Please help me.
I'm waiting for you.Thanks.

xl2007=obvious. Before xl2007 use this.

Sub AddSheetAtEnd()
ActiveWorkbook.Sheets.Add after:= _
Worksheets(Worksheets.Count)
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tara" wrote in message
...
Hello to all.Hope everybody are doing great.
I have a question in Excel 2003.How can I insert another sheet just next
to
the old sheet? for example I have sheet1 sheet 2 sheet 3 I want to insert
sheet 4 to the right of the sheet 3? How can I? because when I do this the
sheet will place to the left.Please help me.
I'm waiting for you.Thanks.

Thanks Don
But I can not undestand what should I do?
Please explain to me.What should I do with these and how to work with them?
I really appreciate your help.

"Don Guillett" wrote:

xl2007=obvious. Before xl2007 use this.

Sub AddSheetAtEnd()
ActiveWorkbook.Sheets.Add after:= _
Worksheets(Worksheets.Count)
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tara" wrote in message
...
Hello to all.Hope everybody are doing great.
I have a question in Excel 2003.How can I insert another sheet just next
to
the old sheet? for example I have sheet1 sheet 2 sheet 3 I want to insert
sheet 4 to the right of the sheet 3? How can I? because when I do this the
sheet will place to the left.Please help me.
I'm waiting for you.Thanks.

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

And David McRitchie has an intro to macros he
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Tara wrote:

Hello to all.Hope everybody are doing great.
I have a question in Excel 2003.How can I insert another sheet just next to
the old sheet? for example I have sheet1 sheet 2 sheet 3 I want to insert
sheet 4 to the right of the sheet 3? How can I? because when I do this the
sheet will place to the left.Please help me.
I'm waiting for you.Thanks.

--

Dave Peterson