Intermediate Excel - Workbooks

The UK's most regular instructor-led training courses.
Training information: excel+training · Excel training courses · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Fiona has attended:
Excel Intermediate course

by - delegate Fiona [1 post] (2008 May 12 Mon, 16:49) Reply

How do you insert multiple worksheets into the workbook, without having to insert them one by one?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Intermediate Excel - Workbooks

by - trainer Tracy platinum contributer [586 posts] (2008 May 13 Tue, 05:31) Reply

Hi Fiona,

If you have already created a worksheet you have to enter new pages individually. However if you wanted to create a new workbook with lets say 6 sheets there is a setting under the Tools>Options>General tab which sets excel to create every new workbook with multiple pages.

Hope that helps

Tracy

· How Excel Training Can Improve Your Company's Sales Process
· Microsoft Excel Features and Functions for Accountants
· Microsoft Excel's Best Kept Secret
· Basic Excel Training
· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks

Please browse our web site to find out more about
excel+training and other Microsoft training courses.

Excel tip:

Change the default location for opening and saving spreadsheets

If you are always opening spreadsheets from and/or saving documents to a specific location that is not My Documents, save time by setting this folder as the default for opening files from and saving files to.

Here's how:
1. Go to Tools - Options.

2. Select the General tab.

3. Enter the pathname of the folder you wish to make the default in the Default File Location box (hint: it will be easier to use Windows Explorer to navigate to this folder, then copy and paste the pathname from the address bar at the top of the Windows Explorer screen).

4. Click OK.

You have now changed the default folder for opening and saving spreadsheets.

View all Excel hints and tips