Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Adding a new worksheet to a workbook at the end of existing workbo

I am trying to add a new worksheet to an existing workbook but I want to add
it at the end after the existing sheets not some place in the middle of
existing sheets.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default Adding a new worksheet to a workbook at the end of existingworkbo

If you use Insert | Worksheet then Excel will add the new sheet next
to the sheet you are on when you issue the command. You can just drag
the tab to the end of the existing tabs to move it (a small arrow will
indicate where it will be moved to).

Hope this helps.

Pete

On Aug 21, 3:19*pm, CBedford12
wrote:
I am trying to add a new worksheet to an existing workbook but I want to add
it at the end after the existing sheets not some place in the middle of
existing sheets. *


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default Adding a new worksheet to a workbook at the end of existing workbo

Right click the last sheettab and insert. Right click the new tabmove or
copyFrom the list select the last option ' Move to end' and hit OK

If this post helps click Yes
---------------
Jacob Skaria


"CBedford12" wrote:

I am trying to add a new worksheet to an existing workbook but I want to add
it at the end after the existing sheets not some place in the middle of
existing sheets.

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
Copy worksheet to 2nd workbook but have no reference to 1st workbo i4004 Excel Discussion (Misc queries) 8 June 24th 08 02:04 AM
ADDING MORE WORKSHEETS TO AN EXISTING WORKBOOK Dave F Excel Discussion (Misc queries) 0 February 15th 07 04:23 PM
Link from worksheet in one workbook to worksheet in another workbo Pam Excel Discussion (Misc queries) 1 November 3rd 06 06:27 PM
Link from worksheet in one workbook to worksheet in another workbo Pam New Users to Excel 1 November 3rd 06 06:27 PM
When opening an existing workbook, Excel opens but not the workbo. llhughes Excel Discussion (Misc queries) 1 February 12th 05 07:41 PM


All times are GMT +1. The time now is 11:48 PM.

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

About Us

"It's about Microsoft Excel"