Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Intermediate Excel - Workbooks

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Intermediate Excel - Workbooks

Resolved · Low Priority · Version 2003

Reply Mon 12 May 2008, 16:49Delegate Fiona said...

Fiona has attended:
Excel Intermediate course

Intermediate Excel - Workbooks

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

For upcoming training course dates see: Pricing & availability

Reply Tue 13 May 2008, 05:31Trainer Tracy said...

RE: Intermediate Excel - Workbooks

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

Excel articles

· Excel Charts As Easy As Pie
· Tell AutoFill What To Do And It Will Oblige
· Microsoft Excel as a Reporting Tool
· From the Classroom to the Corporate World
· How Excel Can Boost Even The Smallest Business

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

Excel tip:

Adding Rows or Columns in an Excel 2010 Worksheet

If you want to add a row to an Excel spreadsheet, these are the simple steps you should take:

With your mouse, right click on the row header below where you want the new row to be added. Then, click Insert.

Follow exactly the same steps if you want to add a column to an Excel worksheet, right click on the column header, choose Insert and the new column will be inserted to the left of the selected column.

View all Excel hints and tips