Modifying A Worksheet

Moving Through Cells

Use the mouse to select a cell you want to begin adding data to and use the keyboard strokes listed in the table below to move through the cells of a worksheet.

Column - Add a column by selecting Insert|Columns from the menu bar, or highlight the column by click on the column label, right-click with the mouse, and choose Insert.

Resizing Rows and Columns
There are two ways to resize rows and columns.

Adding Worksheets, Rows, and Columns

Worksheets - Add a worksheet to a workbook by selectiing Insert|Worksheet from the menu bar.

Row - To add a row to a worksheet, select IInsert|Rows from the menu bar, or highlight the row by clicking on the row label, right-click with the mouse, and choose Insert.

Column - Add a column by selecting Insert|Coluumns from the menu bar, or highlight the column by click on the column label, right-click with the mouse, and choose Insert.

Resizing Rows and Columns
There are two ways to resize rows and columns.

1. Resize a row by dragging the line below the label of the row you would like to resize. Resize a column in a similar manner by dragging the line to the right of the label corresponding to the column you want to resize.
   - OR -
2. Click the row or column label and select Format|Row|Height or Format|Column|Width from the menu bar to enter a numerical value for the height of the row or width of the column.

Selecting Cells
Before a cell can be modified or formatted, it must first be selected (highlighted). Refer to the table below for selecting groups of cells.

To activate the contents of a cell, double-click on the cell or click once and press F2.

Moving and Copying Cells

Moving cells

To cut cell contents that will be moved to another cell select Edit|Cut from the menu bar or click the Cut button on the standard toolbar.