abc MICROSOFT EXCEL 2010 - WORKBOOK
Parts of WORKBOOK
WORKSHEET, COLUMN and ROW

WORKBOOK

WORKBOOK in EXCEL is consists of WORKSHEETS. WORKBOOK is saved in media as a file with .xlsx extension.

WORKSHEET

Worksheet in EXCEL consists of columns and rows. Worksheets are recognised by their TABS (they can be seen in bottom left corner of the screen). For renaming-right click on TAB and from SHORTCUT menu choose RENAME item. Then you can type a new name in dialogue box.

Data is entered in WORKSHEET. WORKSHEET consists of columns and rows and that makes an electronic table. WORKSHEETS are grouped in a WORKBOOK. WORKBOOK usually consists of 3 WORKSHEETS. There has to be at least one WORKSHEET in the WORKBOOK.

WORKSHEET parametres can be changed: WORKSHEET name, WORKSHEET order ect. WORKSHEET can be deleted, selected, inserted, copied ect.

COLUMN

Vertical space from top to bottom is a column. Vertical space from the top to the bottom is called column.. Letters on the top of the column are used to mark it and that is a COLUMN HEADING. We distinguish columns by their letters . The marks start from A to Z and then there are AA, AB, AC ect.. The number of columns and rows in the workshhet is not limited by memory and resources of the computer system.

ROW

Horizontal space from left to right is a row. Number on the left is used to mark the row. Height and wight of columns/rows can be changed.

N o t e: Column/row can be inserted and deleted.


Picture 1. Parts of WORKBOOK

Steps are explained in the following links:

  1. WORKSHEET
  2.    Select worksheet by left click
  3.    Select worksheet - Worksheet bar
  4.    Rename worksheet - Right click
  5.    Rename worksheet - Worksheet tab
  6.    Rename worksheet - Ribbon, Rename sheet
  7.    Moving worksheet tab
  8.    Insert Worksheet by Insert Worksheet button
  9.    Insert Worksheet - Ribbon, Insert Sheet
  10.    Insert Worksheet - Right click
  11.    Insert Worksheet - Keys
  12.    Delete worksheet - Ribbon
  13.    Delete worksheet - Right click
  14.    Copy worksheet

  15. COLUMN

  16.    Select column
  17.    Column width, a column header
  18.    Column width - Ribbon, FORMAT button
  19.    Insert column - Ribbon, INSERT button
  20.    Insert column - Ribbon, Insert button 2
  21.    Insert column - Right click
  22.    Visible/invisble cell content #### – Changing column width by column headings
  23.    Delete Column - Ribbon, Delete
  24.    Delete Column - Right click

  25. Examples
  26.    Insert column example 01
  27.    Delete COLUMN example 01

  28. ROW
  29.    Select Row
  30.    Insert Row - Ribbon, INSERT button
  31.    Insert Row - Right click
  32.    Row height - Row header
  33.    Row height - Ribbon, FORMAT button
  34.    Delete Row - Ribbon, Delete
  35.    Delete Row - Right click

  36. Examples
  37.    Insert row example 01
  38.    Delete row example 01

  39. CELL
  40.    Select cell - Active cell
  41.    Range cell
  42.    NAME BOX
  43.    Move a cell content
  44.    Insert cell(s)
  45.    Insert cell(s) 2
  46.    Inserting a cell - Right click
  47.    Delete name box
  48.    Erasing data
  49.    Delete cell(s)

 Index