Excel Rows

Contents:
insert excel row | delete excel row | hide excel row | unhide row | sizing excel row 

How do I insert a new row in excel? How do I delete a row in excel? How to delete multiple rows in Excel workbook? How to hide a row from being displayed in excel? How to unhide the hidden rows in excel? This post will guide you how to Insert / Delete/ Hide/ Unhide/ Sizing columns in Microsoft Excel.

Insert Row

If you wish to add a new row in current workbook, just following below steps:

Step 1# Select one row or a cell that you want to insert the new row and the new row will be inserted above the selected row. For example: Select row 2 or A2 cell.

excel row select cell

Step 2# Right-click and then click “Insert…

excel row right click

Step 3# A “Insert” window will appear. Then click “Entire row” radio button.

excel row insert entire row

Step 4# Let’ see the result.

excel row inserted row 2

Delete Row

If you wish to delete one row or multiple rows in current workbook, just following below steps:

Step 1# Select a cell or a row that you want to delete. For example: select row 3 or A3 cell.

excel row delete row

Step 2# Right-click and then click “Delete…

excel row delete right click

Step 3# A “Delete” window will appear. Then click “Entire row” radio button. Click “OK” button.

excel row delete entire row

Step 4# Let’ see the result.

excel row deleted row 3

Note: if you want to delete multiple rows, you just need to select those rows, then right-click on it.  next, click “Delete”. All rows you selected will be deleted immediately.

Hide row

The below steps will explain that how to hide a row in excel.

Step 1# Select row that you wish to hide via clicking row number.

excel row hide

Step 2# Right-click on row 3, then click “Hide

excel row hide right click

Step 3# Let’s see the result, row 3 should be hidden.

excel row hidden

Unhide row

If you wish to unhide the hidden row, please refer to the below steps:

Step 1# Select the rows that contain the hidden row. For example, row 3 was hidden, now we need to select row 2 and row 4.

excel row unhide

Step 2# Right click and select “Unhide

excel row unhide right click

Step 3# The hidden row should be unhidden, let’s see the result.

excel row unhide row 2

Sizing row

Sometimes, we wish to change the height of a row in excel, the below steps will guide you how to change the row height.

Step 1# Select row that you want to change height via clicking row number.

Step 2# Right-click and then click “Row Height…

excel row height change

Step 3# A “Row Height” window will appear.

excel row height change window

Step 4# Input new value for Row height, such as: 30, then click “OK” button.

excel row height change window value

Step 5# Let’s see the result. Row 3 should be the new row height.

excel row height changed

Leave a Reply