Inserting Worksheets

[Leslie Coover]

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

 

[Jim Cone]

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



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

 

[Leslie Coover]

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

 

[Ken Wright]

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
------------------------------­------------------------------­----------------