Inserting Worksheets to the RIGHT

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

Guest

Does anyone know how to insert a new worksheet to the RIGHT of the currently selected tab

Please help
Please Email responses to

(e-mail address removed)

Thanks

Gabe
 
Two ways:

Click (and hold) on a tab you may wish to copy. Press
(and hold) the Ctrl key. Drag the worksheet to the right.
Release both the mouse button and the Ctrl key. The sheet
will then be copied to the right.

Insert a new worksheet. It will appear to the left.
Select, drag and move it to the right.

Allan
-----Original Message-----
Does anyone know how to insert a new worksheet to the
Click to expand...
RIGHT of the currently selected tab?
 
Gabe,

This is possible only with some VBA code:


With ThisWorkbook.Worksheets
.Add after:=.Item(ActiveSheet.Index)
End With



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Why not just insert a new sheet then drag and drop it to
the right of the other sheets?

Blaster
-----Original Message-----
Does anyone know how to insert a new worksheet to the
Click to expand...
RIGHT of the currently selected tab?
 
Back
Top