I need your help guys please

  • Thread starter Thread starter Tara
  • Start date Start date
T

Tara

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
 
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.
 
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
 
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
 
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)
 
xl2007=obvious. Before xl2007 use this.

Sub AddSheetAtEnd()
ActiveWorkbook.Sheets.Add after:= _
Worksheets(Worksheets.Count)
End Sub
 
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
 
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.
 
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.
 
Back
Top