View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How do I add NOT insert additional worksheet to existing workbook.

Excel 2007 little "add" button inserts sheet at end no matter which sheet is
selected.

Shift F11 inserts sheet before selected sheet.

There is no little "add" button in Excel 2003 and Shift F11 inserts sheet
before selected sheet...........as does "insert sheet"


Gord Dibben MS Excel MVP

On Sun, 01 Nov 2009 04:59:45 -0800, Archimedes' Lever
wrote:

On Sun, 1 Nov 2009 09:16:29 -0400, "Bernard Liengme"
wrote:

Yes, but that inserts the sheet BEFORE the current one NOT at the end of the
tabs
Your lever is rusty today!



Absolutely not. It placed it AT the end when I did it, both the little
"add" tab did, as well as the Shift+F11 usage.

Perhaps it relates to which tab is currently active.