Creating copying and moving sheets in Excel workbooks

The Excel worksheet – is the workspace under the toolbar. This sheet consists from a set of cells arranged among it selves relative to rows and columns.

Its appearance resembles to a large table. There are 3 sheets are default in each new Excel workbook.

For the user, the sheet is a file with a document that is nested in the folder (Excel workbook). Sheets can and should be managed. The sheets can be moved in other workbooks. This operation saves a lot of time than just copying and transferring the contents of the sheet itself.



Excel sheets as a data environment

In a standard book, each sheet is the large tables, that are filled with data and formulas. How to add a sheet in Excel? As necessary, you can insert the additional sheets (SHIFT+F11) or delete unused ones. To create a new worksheet in Excel, you can clicking on the last tab of the sheets, as it shown in the picture:

Excel sheets.

The book can contain from 1 to 255 sheets.

How do I copy a worksheet to Excel? For fast implementation of this task it is necessary:

  1. To point the mouse cursor on the sheet tab (shortcut) that you need to copy.
  2. To make the click with the left button of the teddy bear, holding down the button + CTRL key and move the cursor to the place of the bookmarks where the copy should be inserted.
CTRL copy the sheet.

If there are too many sheets, or if you need to copy / move a sheet to a new workbook, then we do the following:

  1. Right-click on the bookmark tab (shortcut) to call the context menu, where we select the option «Move or Copy ...».
    2. Move or Copy.
  2. In the window that appears, we configure the parameters for copying the worksheet. From the top you need to choose what of the opening work books should copy. Below we indicate, what sheets to insert a copy between.
    3. copying the worksheet.
  3. If we copy the sheet, but do not transfer it, check the «Create a copy» option.


The exercises with sheet elements

Task 1: Click on each element shown in the picture above and try to remember its location, name.

Task 2: Click on the tabs located in the bottom (Sheet2, Sheet3 and Sheet1) alternately. After clicking, the tab of each sheet becomes active, and its bookmark is highlighted.

Note: each book can contain a lot of sheets (up to 255 pcs.), similar to how the folder contains files.

Various operations with sheets will be considered in the following lessons.

Working with Sheet Cells

The most important element of the sheet is the cell. Each cell has its own sequence number relative to the rows and a Latin letter relative to the columns. Thus, each cell has its own address (like cells in a chessboard). That is, the first cell (in the upper left corner) has the address A1, and under it the cell with the address A2. On the right side of the cell address B1, etc.

The number of rows in each sheet of Excel 2010 is slightly more than one million, more precisely is 1 048 578 pcs. The number of columns is much smaller - 16 384 pcs.

Pay attention! After 26 Latin letters, the name of the columns is no longer of one, but of 2 or more letters in logical, alphabetical order. Thus, the address of the last cell in the bottom-right corner of the sheet is XFD1048578.

Each cell can be written:

  • text;
  • number;
  • date and time;
  • formulas;
  • logical expressions.

Each cell can be formatted and assigned a note. All data and cell formatting styles can be changed. It is also worth noting that formatting the borders of cells is the key basis for designing the appearance of tables (for example, for printing forms, etc.).

All Classes

en ru