Inserting worksheets

[kevs]

I just learned inserting worksheets. It seems real crazy. You choose insert
worksheet from menu and it inserts a sheet to the left? What's the logic of
this? 4, 5, 1,2,3?

Or right click on a worksheet tab, and the project gallery comes up? You
select "worksheet" and new worksheets overwrite the number of a preexisting
worksheet tab?. I've got a workbook now (just a test) that says at bottom,
worksheet 1,2,5,7?

Wouldn't be nicer to have tabs in sequential order?

Any comments appreciated. Thanks!
Kevs

 

[Jim Gordon]

Hey Kevs,

Ya know, that's always bugged me but I don't think I ever told Microsoft
about how I felt about that little sheet number strangeness. I think I'll
mention it via feedback.

You and anyone else who finds the number scheme a bit odd should use the
feedback feature on Excel's help menu, or send feedback via this link:
http://register.microsoft.com/mswish/suggestion.asp

You're not supposed to get the project gallery when you control-click
(right-click) a sheet tab. You should get a context sensitive menu. One of
the items on that menu is INSERT, and I think you might have chosen that
one. Pay special attention to what the project gallery is displaying. You
can create some very special kinds of worksheets using that feature.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

 

[J.E. McGimpsey]

I just learned inserting worksheets. It seems real crazy. You choose insert
worksheet from menu and it inserts a sheet to the left? What's the logic of
this? 4, 5, 1,2,3?

Or right click on a worksheet tab, and the project gallery comes up? You
select "worksheet" and new worksheets overwrite the number of a preexisting
worksheet tab?. I've got a workbook now (just a test) that says at bottom,
worksheet 1,2,5,7?

Wouldn't be nicer to have tabs in sequential order?

That works if you're (a) not renaming your worksheets, and (b) only
adding worksheets to the right end of your workbook.

I agree that it would make more sense strictly from a numbering
perspective for the Insert/Worksheets command to insert sheets to
the right of the selected sheets, but how would that reconcile with
the behavior of Insert/Columns which inserts columns to the left and
pushes existing columns to the right. The User Interface should work
constently and the current method of insert/worksheet is
functionally consistent with insert/columns.

However, even if it did insert worksheets to the right, if I've got
Sheet2 active in a book with sheets in the order
Sheet1,Sheet2,Sheet3, I'd like to see the sheet inserted between
Sheet2 and Sheet3, not on the extreme right (that wouldn't be
"inserting" in the sense of any other insert operation). And it
would be "out of order" in any case: I don't see
Sheet1,Sheet2,Sheet4,Sheet3 as an improvement over XL's current
Sheet1,Sheet4,Sheet2,Sheet3.

For me it's usually a moot point - I almost never leave sheet tabs
with the default name, rather giving them meaningful names like:

5-yr projection, Payroll, Plant, Variable Cost, Taxes

etc., so I don't really care about what arbitrary sheet name XL
chooses.

And for goodness sake, *DON"T EVEN THINK* about overwriting the
name/number of an existing sheet - it would make any INDIRECT()
formula or reference from an external workbook immediately invalid
with *zero* hope of recovery without doing a *manual* cell-by-cell
evaluation.

If it really bothers you, put one of these macros in your Personal
Macro Workbook and attach it to a toolbar button, keyboard shortcut,
or even reassign the Insert/Worksheet menu item:

Public Sub InsertWorksheetRight()
ActiveWorkbook.Worksheets.Add After:=ActiveSheet
End Sub


Public Sub InsertWorksheetLast()
With ActiveWorkbook
.Worksheets.Add After:=.Sheets(.Sheets.Count)
End With
End Sub

Of course, if you want to sort your sheets, Chip Pearson has a macro
that will do it painlessly:

http://www.cpearson.com/excel/sortws.htm

 

[kevs]

That works if you're (a) not renaming your worksheets, and (b) only
adding worksheets to the right end of your workbook.

I agree that it would make more sense strictly from a numbering
perspective for the Insert/Worksheets command to insert sheets to
the right of the selected sheets, but how would that reconcile with
the behavior of Insert/Columns which inserts columns to the left and
pushes existing columns to the right. The User Interface should work
constently and the current method of insert/worksheet is
functionally consistent with insert/columns.

However, even if it did insert worksheets to the right, if I've got
Sheet2 active in a book with sheets in the order
Sheet1,Sheet2,Sheet3, I'd like to see the sheet inserted between
Sheet2 and Sheet3, not on the extreme right (that wouldn't be
"inserting" in the sense of any other insert operation). And it
would be "out of order" in any case: I don't see
Sheet1,Sheet2,Sheet4,Sheet3 as an improvement over XL's current
Sheet1,Sheet4,Sheet2,Sheet3.

For me it's usually a moot point - I almost never leave sheet tabs
with the default name, rather giving them meaningful names like:

5-yr projection, Payroll, Plant, Variable Cost, Taxes

etc., so I don't really care about what arbitrary sheet name XL
chooses.

And for goodness sake, *DON"T EVEN THINK* about overwriting the
name/number of an existing sheet - it would make any INDIRECT()
formula or reference from an external workbook immediately invalid
with *zero* hope of recovery without doing a *manual* cell-by-cell
evaluation.

If it really bothers you, put one of these macros in your Personal
Macro Workbook and attach it to a toolbar button, keyboard shortcut,
or even reassign the Insert/Worksheet menu item:

Public Sub InsertWorksheetRight()
ActiveWorkbook.Worksheets.Add After:=ActiveSheet
End Sub


Public Sub InsertWorksheetLast()
With ActiveWorkbook
.Worksheets.Add After:=.Sheets(.Sheets.Count)
End With
End Sub

Of course, if you want to sort your sheets, Chip Pearson has a macro
that will do it painlessly:

http://www.cpearson.com/excel/sortws.htm

Jim: thanks for the feedback advice, I had never even seen that before in
help menu.

JE: Your right! In fact the whole idea of using a worksheet beyond the
workbook related to my previous question about how to select non contiguous
columns and print them out, and then it was suggested to just highlight what
you want and put that in a worksheet. And of course, renaming it something
useful is best name of all. Thanks again!