The Excel worksheet is made up of cells in columns and rows and is reference by the letters going across the top and the numbers going down the side.

When you click a particular cell, the cell becomes active and its reference appears on the left side of the formula bar.

Only when a cell is active can you type data into it. These can either be labels or values.

Labels are uses to identify the data in the rows and columns of a worksheet.

They are also used to make your worksheet readable and understandable.

To enter a number as a label instead of a value put an apostrophe in front of the number for example the year 1998 would become '1998. You can have up to 256 columns and 65536 rows on a worksheet.

Insert worksheets

• To add further worksheets click on 'Insert', highlight 'worksheet' and press enter.
• To put worksheets in order click on the tab and drag it into place
• Or Alt + I for the insert drop-down menu
• W to insert worksheet
• Alt + E for edit drop-down menu
• M for move or copy dialog box
• Down arrow to move to end
• Tab to OK button
• Enter

Sheet tabs
Are located below the worksheet grid. They enable you to keep your work in collections called workbooks.

• To name a worksheet, double click on the tab and type in name.
• Or Alt + O for the format drop-down menu
• H for the sheet sub-menu
• R for re-name option

Type in name
Each workbook contains 3 sheets by default and can contain a maximum of 255 sheets.

Insert rows or columns

• Highlight where you require the row or column to be inserted
• Selected the insert drop-down menu.
• Highlight either row or column and press enter.
• Or Alt + I for the insert drop-down menu
• R or C for row or column

Delete rows or columns

• Highlight the row or column that you require deleting.
• Select edit drop-down menu and highlight delete.

The delete box will drop down.

• Select the option required by pointing and clicking the left-hand mouse button and pressing enter.
• Or Highlight the row or column that you require deleting.
• Select edit drop-down menu
• D for delete dialog box
• R or C for Row or Column and enter

Hide or unhide cell or columns
To hide cells or columns on your worksheet highlight the cells or columns that need hiding

• Select format menu
• Select rows or columns
• Select hide or unhide

The hidden columns or cells will not print out.

• Or Alt + O for the Format drop-down menu
• R or C for row or column sub-menu
• H or U for hide or un-hide