Ozgrid, Experts in Microsoft Excel Spreadsheets




Lesson 4 - Insert/Delete/Name/Move Worksheets



All Workbooks must contain at least one Worksheet. The maximum number of Worksheets a Workbook can contain is limited only by the available memory of the PC. As a default, Excel places three blank Worksheets in front of you. Each one of these has the default name Sheet1, Sheet2, Sheet3 at the bottom. By default all Worksheets are identical in that they contain Rows, Columns and Cells (all discussed below).

NOTE: You can change the default of three blank Worksheets by going to Tools>Options/General and changing Sheets in new workbook: by typing in the number you require.

All Worksheets contains 256 columns and 65,536 rows. Each separate rectangle within the Worksheet is called a Cell. You will notice letters across the top of your Worksheet. These are the names of the columns and go from A through to IV. The numbers down the left hand side of your sheet of graph paper symbolise row headings and go from 1 through to 65,536. Inserting Worksheets

Adding new Worksheets to a Workbook can be done in a number of ways. The most common are:

  • Go to Insert>Worksheet
  • Right click on another Sheet name tab and select Insert and then select Worksheet.

There is another way that is not exactly inserting a new Worksheet, but rather making a copy of an existing Worksheet.

To do this, select the Sheet you want to copy then left click on the name tab and holding down the Ctrl key (bottom left hand side of your keyboard), then drag it to one side, then release. This is a great time saver when you have spent hours setting up a Worksheet with all the formatting you want. You will notice that Excel will place a number after the copied sheets name in brackets. This is because we cannot have two Worksheets of the same name in the same Workbook. Name and Renaming Worksheets is covered later. Deleting Worksheets

The logical opposite to inserting Worksheets is Deleting them. This can be done in any of the following ways.

  • Right click on the Worksheets name tab and select Delete
  • Go to Edit>Delete. . . . .  the Delete dialogue box will appear with options, select your option and click OK to verify your request.

Whichever method we use, Excel will display a warning message letting us know that the deletion cannot be undone. This is not technically true as we could always close our Workbook WITHOUT saving and then re-open the Workbook, but of course this means we would loose any other changes we had made. Naming Worksheets

We can also name our Worksheets with meaningful names (which is a good idea!). The only restrictions we have with Worksheet names is:

While it is not totally necessary, try to AVOID using spaces between words. For example, if you wanted to name a Worksheet Bills Hours use BillsHours instead! The reason for this is that some of Excels formulas have slight problems when they reference Worksheets that contain spaces.

To name a Worksheet we can do so with any of the most methods below:

Moving Worksheets

At times we may need or wish to move a Worksheet to another position in the Workbook or even to another Workbook. We have already looked at how we can make a copy of a Worksheet, select the Sheet you want to copy then left click on the name tab and holding down the Ctrl key drag it to one side, then release. If we do not want to copy but rather move the entire Worksheet to another position in the Workbook we can simply left click the Worksheet Name tab, then holding down the mouse button drag it to it's new position and release. The other method is to use the Move or the Copy dialogue box. This can be accessed in two ways.

It makes no difference which method you use! You will see on this dialogue box a To book: box with a small drop arrow to the right. The selection in this box will determine where our sheet will be moved or copied to. The default name in this box will be the active Workbook name (the current Workbook we are in). There will also always be another choice, if we click the drop arrow. This is (new book), if we choose this option Excel will automatically create a new Workbook for the sheet to be moved or copied to. Within this box will also be the names of any other open Workbooks, should there be any.

Directly below the To book: box is the Before sheet: box. Our selection in this box will decide which position our sheet will be moved or copied to. Last of all is the Create a copy checkbox. If we check this box Excel will create a copy of our moved Worksheet. In other words our original sheet will remain where it is and a copy of it will be moved to our chosen location. If we leave it unchecked (which is the default) the Worksheet will be moved and not copied. The best way (as with most of excel) is to jump straight in and try out different options - you cannot do any harm!

Click here to see how an efficient spreadsheet should be set up in Excel.

Go To Free Excel Training Lesson 5 .  Back to Previous Lesson

Go to Excel Basic/Level 1 Training Index


Instant Download and Money Back Guarantee on Most Software


Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel | MSSQL Migration Toolkit | Monte Carlo Add-in | Excel Costing Templates