Rows and columns
Prev  Chapter 2. Cells  Next

Rows and columns

Abstract

Insert rows, columns in a worksheet

Insert a single row

Suppose we have the file Demog.sxc displayed:

We now wish to insert a row after % Urban with the row heading % High school education.

  1. Position the cursor anywhere in row 8.

  2. Insert->Rows

    [Note] Note

    Note when you execute this command, the new row is inserted before the current row. Row 8 is now a blank row.

  3. Click on A8 and type the text % High school education.

Insert several rows

Suppose you wished to insert three rows after % Urban.

  1. Select rows 8 to 10.

  2. Insert->Rows

    This will insert three new rows 8 to 10. The previous rows 8 to 10 will be shifted down.

Insert one or more columns

The process of inserting one or more columns is done in a similar way:

  1. Select the columns.

  2. Insert->Columns

Existing columns will be shifted to the right.

Delete rows, columns in a worksheet

  1. Select the rows or columns to be delete. These may be adjacent or not.

  2. Edit->Delete cells

    This will bring up the Delete cells dialogue.

  3. Click on the Delete entire row(s) or Delete entire column(s) radio button as appropriate.

  4. Click OK.

Modify column widths, row heights

Resize column widths using the mouse

  1. Position the cursor on the right hand border on the column letter box.

  2. Hold down the left hand mouse button and drag the border to the left or right.

    As you do the width of the column will be displayed.

[Important] Important

You can only use the right hand border for adjusting the column width.

Resize rows heights using the mouse

  1. Position the cursor on the lower border of the row number.

  2. Hold down the left hand mouse button and drag the border down or up.

[Important] Important

You must use the lower border of the cell. If you drag the upper border of a cell, you will change the row height of the cell above. For example, instead of making the lower cell wider, you will make the upper cell narrower.

Resize one or more columns using Format

  1. Select the column(s) whose width you wish to change (or press Ctrl+A to select all the columns).

  2. Format->Column->Width

    This brings up the Format column width dialogue.

  3. Enter a value in the Width window and click OK.

OR

  • Check the Default value check box to select the default column width and Click OK.

Resize one or more rows using Format

  1. Select the row(s) whose height you wish to change (or press Ctrl+A for all the rows).

  2. Format->Row->Height. This brings up the Format row height dialogue.

  3. Check the Default value check box to select the default row height and Click OK.

OR

  • Enter a height into the Height window and click OK.

Prev  Up  Next
Select cells  Home  Edit data