Inserting Worksheets
 

Is there a setting that I can change so that when I insert a worksheet
(while in the Excel Window) the new worksheet will be placed at the END of
the ones I already have, instead of BEFORE THE LAST ONE?

Thanks, Les Coover

Inserting Worksheets
 

Les,

I believe a new worksheet is inserted to the left of the active sheet.
There is no way that I know of to change this behavior without
using VBA programming code.
However, one can change the placement of any sheet by clicking
the worksheet tab and dragging it to the position desired.

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Leslie Coover" wrote in message
news:kI_Lf.20533$2c4.2135@dukeread11...
Is there a setting that I can change so that when I insert a worksheet
(while in the Excel Window) the new worksheet will be placed at the END of
the ones I already have, instead of BEFORE THE LAST ONE?

Thanks, Les Coover

Inserting Worksheets
 

Thanks! This is a big help, I was unaware of the click and drag.

"Jim Cone" wrote in message
...
Les,

I believe a new worksheet is inserted to the left of the active sheet.
There is no way that I know of to change this behavior without
using VBA programming code.
However, one can change the placement of any sheet by clicking
the worksheet tab and dragging it to the position desired.

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Leslie Coover" wrote in message
news:kI_Lf.20533$2c4.2135@dukeread11...
Is there a setting that I can change so that when I insert a worksheet
(while in the Excel Window) the new worksheet will be placed at the END of
the ones I already have, instead of BEFORE THE LAST ONE?

Thanks, Les Coover

Inserting Worksheets
 

Also, if you actually copy an existing worksheet to use as a template using
the 'move/copy' option, then you can specify that you want it at the end of
the worksheet.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Leslie Coover" wrote in message
news:0s2Mf.20543$2c4.10640@dukeread11...
Thanks! This is a big help, I was unaware of the click and drag.

"Jim Cone" wrote in message
...
Les,

I believe a new worksheet is inserted to the left of the active sheet.
There is no way that I know of to change this behavior without
using VBA programming code.
However, one can change the placement of any sheet by clicking
the worksheet tab and dragging it to the position desired.

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Leslie Coover" wrote in message
news:kI_Lf.20533$2c4.2135@dukeread11...
Is there a setting that I can change so that when I insert a worksheet
(while in the Excel Window) the new worksheet will be placed at the END
of
the ones I already have, instead of BEFORE THE LAST ONE?

Thanks, Les Coover