How do I delete rows or columns from my worksheet?

Method One:

1. Click the header of the row(s) or column(s) you wish to delete.
2. Right Click.
3. Click ‘Delete’.

Method Two:

1. Click the header of the row(s) or column(s) you wish to delete.
2. In the ‘Home’ ribbon, click the ‘Delete’ drop down menu.
3. Click ‘Delete Sheet Rows/ Columns’.

How do I insert a row or column into a worksheet?

New columns are inserted to the left of the selected cell. New rows are inserted above the selected cell.

Method One:

1. Click the header of the row BELOW/column to the RIGHT of where you want the row/column inserted.
2. Right click on the row/column header.
3. Click ‘Insert Sheet Row/Column’.

Method Two:

1. Click the header of the row BELOW/column to the RIGHT of where you want the row/column inserted.
2. Click the ‘Insert’ drop down menu.
3. Click ‘Insert Sheet Rows/Columns’.

How do I insert more than one row or column into a worksheet?

1. Select the number of rows or columns to be inserted BELOW (rows) or to the RIGHT (columns) of where you want them inserted. For example to insert 5 columns select the 5 columns to the right of where you want them inserted.
2. Right click.
3. Click ‘Insert’.

How do I change the column width or row height?

1. Position the mouse pointer between the column or row headers.
   The cursor will change in appearance to that illustrated opposite.
2. Press and hold the left mouse button.
   • COLUMNS: Drag the cursor to the right (enlarge width) or to the left (reduce width).
   • ROWS: Drag the cursor up (enlarge height) or down (reduce height).
     As you drag the cursor a line illustrates the new width of the column or height of the row. The size (indicated in characters and pixels) is also indicated above the cursor. (48 pixels = .5 inch)
3. Release the mouse button.