What Is A Worksheet?

 

A worksheet is a collection of cells where all your data and formulas are stored. Each cell can contain either data (numeric or text) or a formula.

 

001-Worksheet-Area Worksheet Area

 

Cells are arranged in rows and columns in the workbook. Rows are labelled with numbers going from 1 at the very top to 1,048,576 at the very bottom. Columns are labelled with letters going left to right starting with A and going to XFD. Since there are only 26 letter in the alphabet, the column label convention starts with A to Z for the first 26 columns, then moves onto AA, AB,…, AZ, BA, BB,… until we get to ZZ and the process starts again at AAA and goes on until the 16,384 th column which is labelled XFD. The intersection of a column and a row is a cell and the address of this cell is given by its column letter and row number.

 

002-Worksheet-Area Worksheet Area

 

One cell in the worksheet is called the active cell. This means you can edit its contents or enter new data or formula into the cell by typing on your keyboard. You can identify the active cell in the worksheet by:

  1. A thick dark green border around the cell.
  2. The associated column and row will be a darker shade of gray.
  3. The cell’s address will appear in the Name Box.

 

Selecting A Worksheet

 

By default a new Excel workbook contains 3 worksheets, but you can change the default number of sheets in a new workbook to any number you like.

 

003-Worksheet-Area Worksheet Area

 

Only one worksheet is visible at a time, this is called the active worksheet. Select a different sheet by clicking on it from the sheet tabs at the bottom of the workbook, or use the Ctrl + Page Up and Ctrl + Page Down keyboard shortcuts to scroll through all the sheets in the workbook.

 

Renaming A Worksheet

 

The default names Excel gives worksheets are pretty generic (Sheet1, Sheet2, Sheet3 etc…) but you can change them to something more meaningful, so if your sheet contains sales data you might name it Sales Data.

 

004-Worksheet-Area Worksheet Area

 

Rename a worksheet.

  1. Right click on the sheet which you want to rename.
  2. Select Rename from the menu. Type your new name then press Enter.

 

You can also rename a worksheet by double left clicking on the sheet tab.

 

Deleting A Worksheet

 

005-Worksheet-Area Worksheet Area

 

Delete a worksheet.

  1. Right click on the sheet which you want to delete.
  2. Select Delete from the menu.

 

You can also delete a worksheet from the Home tab in the Cells section by going to Delete then Delete Sheet.

 

Inserting A Worksheet

 

006-Worksheet-Area Worksheet Area

 

Insert a worksheet.

  1. Right click on any sheet.
  2. Select Insert from the menu.
  3. Alternatively, press the small plus sign icon to the right hand side of all the sheets.

 

You can also insert a worksheet from the Home tab in the Cells section by going to Insert then Insert Sheet.

 

Moving A Worksheet

You can move sheets around to arrange them into any order you like.

 

007-Worksheet-Area Worksheet Area

 

Left click on the sheet which you want to move, hold the mouse button down and drag the sheet to the desired location. A small sheet icon will display on your cursor while you are dragging the sheet to its new location.

 

Moving or Copying a Worksheet

 

For more options like moving a sheet to another workbook or making a copy of the sheet, use the Move or Copy command from the right click menu.

 

008-Worksheet-Area Worksheet Area

 

Move or Copy a worksheet.

  1. Right click on the sheet which you want to move or copy.
  2. Select Move or Copy from the menu.
  3. If you want to move or copy the sheet to a different workbook then select the workbook from the drop down menu. Note that you will only be able to choose a new workbook or a currently open workbook from the drop down menu.
  4. Select the location to move the sheet to.
  5. Check the Create a copy box to make a copy of the sheet.
  6. Press the OK button to make the changes.