To rename worksheet

• Double click on the name tab (sheet1), type in your name plus the figure 2
• Press the 'enter key' on the keyboard
• OR Alt + O for format menu
• Down arrow to sheet
• Right arrow to re-name in the sub-menu
• Type new name and press enter

Now we have finished the calculations of the spreadsheet we want to enhance the appearance of it. We do this by using Excel's formatting commands.

Formatting
Highlighting

• To highlight 'A Cell' - Double click on the Cell
• Or Shift + Right Arrow Key
• To highlight 'More than One Cell' - Click on the first cell press and hold shift key then click on the last cell to be highlighted.
• Or hold down the Shift key and press the Right arrow key the number of cells you want to highlight
• To highlight whole row - Click on row number
• To highlight whole column - Click on column letter
• Or hold down the Shift key and press the Down arrow key the number of cells you want to highlight
• Highlight all the figures
• Select the currency icon.

Merge cells to span several columns or rows
Microsoft Excel places only the upper-leftmost data in the selected range into the resulting merged cell.

• To include all data in the range in the merged cell, copy the data into the upper-leftmost cell within the range.
• Select the cells you want to merge.
• To merge cells in a row and center the cell contents, Click Merge and Center on the Formatting toolbar.
• To merge any selection of cells within a row or column, click Cells on the Format menu, click the Alignment tab, and then select the Merge cells check box.

Example:

• Highlight cells A1 to F1 on last exercise.
• Click on the merge and centre icon on the format toolbar
• Click outside the table.
• Or highlight cells A1 to F1 on last exercise
• F10 then Ctrl + Tab to format toolbar
• Right arrow key to merge and centre icon
• Press Enter

Example:

• Highlight cells A3 to F3 on last exercise.
• Click on the merge and centre icon on the format tool bar
• Click outside the table.
• Or highlight cells A3 to F3 on last exercise
• F10 then Ctrl + Tab to format toolbar
• Right arrow key to merge and centre icon
• Press enter

Split a merged cell into separate cells

• Select the merged cell. On the Format menu
• Select Cells,
• Click the Alignment control tab
• Or arrow key to it
• Clear the Merge cells check box

Rotate text in a cell

• Select the cells in which you want to rotate text.
• On the Format menu, select Cells
• Select the Alignment tab.
• In the Orientation box, click a degree point, or drag the indicator to the angle you want.
• Tab to orientation degree - Up-arrow to increase degree or Down-arrow to decrease degree