When working with a workbook, you may need to insert, delete, move, or hide rows and columns. Here's how to do it:

Inserting Rows

To insert a row, select the row heading below where you want the new row. For example, to insert a row between rows 4 and 5, select row 5.

Click the Insert command on the Home tab. The new row will appear above the selected row.

When you insert rows or columns, a paintbrush icon appears next to the new cells. This lets you choose the formatting for the new cells. By default, Excel formats the new cells like the row above.

Inserting Columns

To insert a column, select the column heading to the right of where you want the new column. For example, to insert a column between columns D and E, select column E.

Click the Insert command on the Home tab. The new column will appear to the left of the selected column.

Make sure you select the entire row or column. If you only select a cell, Excel will only insert a new cell.

Deleting Rows or Columns

To delete a row or column, select the one you want to delete. For example, to delete row 9, select it.

Click the Delete command on the Home tab. The selected row or column will be deleted, and the others will shift.

If you only want to remove the contents without shifting other rows or columns, right-click the row or column heading, and select Clear Contents.

How to Move a Row or Column

Sometimes, you may need to rearrange the content of your worksheet by moving a row or column. In this example, we’ll move a column, but the steps for moving a row are the same.

1. Select the Column
   Click on the heading of the column you want to move. This will highlight the whole column.

   
   
   

2. Cut the Column
   Go to the Home tab and click the Cut command, or press Ctrl+X on your keyboard.

   
   
   

3. Select New Location
   Click the heading of the column to the right of where you want to move your column. For example, if you want to move the column between E and F, click on F.

   
   
   

4. Insert the Cut Column
   Go back to the Home tab. Click the Insert command and select Insert Cut Cells from the drop-down menu.

   
   
   

5. Column Moves
   Your column will now be moved to the new location, and the other columns will shift to make space.

   
   
   

You can also right-click to access the Cut and Insert options from the menu.

This is how you move a column or row in Excel. It’s a quick way to rearrange your data!

To hide and unhide a row or column:

Sometimes, you may want to compare certain rows or columns in Excel without changing the layout of your worksheet. Excel makes it easy to hide and unhide rows and columns.

Here’s how to hide columns:

1. Select the columns you want to hide.
2. Right-click the mouse and choose "Hide" from the menu.
   In our example, we’ll hide columns C, D, and E.

Once hidden, the columns will disappear, but you’ll see a green line where the columns were. This shows where the columns are hidden.

To unhide the columns:

1. Select the columns on both sides of the hidden ones. For example, select columns B and F.
   
   
   
2. Right-click and choose "Unhide" from the menu.
   
   
   

The hidden columns will reappear, and your worksheet will be back to normal.