Unit 2 Summary

It is difficult to think of any "real world" examples of spreadsheets where modifications will not need to be made in the initial appearance. If nothing else, you will need to change column widths, by using Format, Column, AutoFit or by dragging the column's edge on the frame area.

To insert or delete columns or rows, click on the column letter or the row number in the frame area; then select Insert from the menu bar, and pick Columns or Rows, depending on which you want.

To delete columns or rows, select the item and click on Edit on the menu bar, then Delete. This removes rows or columns which are empty or have information. Use the "Undo" button to reverse the last action.

To copy a formula, click and drag on the "AutoFill" button in the lower right corner of a cell. When formulas are copied, they are adjusted to reflect their new location.

To move a cell, click and drag on its border. When cells are moved that have formulas, the formula is not adjusted or changed.

Some other common modifications are to use bold, italic or change the font style or the font size. Only limited font sizes are shown on the "Font Size" list.

The alignment buttons on the Formatting toolbar let you center, left or right justify information in a cell. The "Increase Decimal" or "Decrease Decimal" style buttons change the display of decimal numbers, but can only be applied to number areas.

Learning Excel - Index