Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding a new worksheet to a workbook at the end of existing workbo CBedford12 Excel Discussion (Misc queries) 2 August 21st 09 03:34 PM
How do I apply a template to one worksheet in existing workbook? Gwen Excel Discussion (Misc queries) 0 June 19th 07 02:55 PM
Need to insert a template with formulas into an existing workbook Benny Excel Worksheet Functions 1 September 6th 06 10:37 PM
How do I insert a new work sheet into an existing workbook? lesgold80 Excel Discussion (Misc queries) 1 March 20th 06 09:44 PM
Can't Insert of remove worksheet in an existing workbook beginer1 Excel Discussion (Misc queries) 4 January 25th 06 03:06 AM


All times are GMT +1. The time now is 04:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"