adding sheets to workbooks

  • Thread starter Thread starter ann marie
  • Start date Start date
A

ann marie

How can I add sheets to an Excel 2000 workbook, as I used
to be able to add a sheet with the excel 97?
 
ann

Right-click on an existing sheet and left-click on Insert. Select the type
you require (usually Worksheet) and click OK

Andy
 
In addition to inserting a sheet with the right click on
an existing sheet method you could also drag and drop one
of the existing sheet by holding the [CTRL] key down while
left clicking the existing sheet and dragging it to the
right one or more sheets or to the left at least 2
sheets. This is very useful when the sheet you want
inserted is very similar to or exactly the same as an
existing sheet.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Save all sheets in a new workbook 7
move worksheet to end of another workbook 3
Excel Macro to un-mute Audio/speakers. 15
Excel shortcut options 0
Excel, assign cells in multiple worksheets from one sheet 1
Help for sharing a worksheet from a excel sheet 1
How do I protect Excel Workbook Structure except adding new sheets 3

Back
Top