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
  25.    Insert column example 01
  26.    Delete COLUMN example 01

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

    35. Examples
  35.    Insert row example 01
  36.    Delete row example 01

  37. CELL
  38.    Active cell
  39.    Range cell
  40.    NAME BOX
  41.    DELETE NAME BOX
  42.    Erasing data
  43.    Move a cell content
  44.    Insert cell(s)
  45.    Insert cell(s) 2
  46.    Delete cell(s)

 Index