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.

x
How to Unmerge Cells and Fill Down Values in Excel

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

Related Posts

Quickly Insert Multiple Rows or Columns in Excel
insert multiple rows or columns13

This post will guide you how to quickly insert multiple rows or columns in your Microsoft worksheet. You will see that how to add new multiple rows or columns with shortcut or insert feature, or insert copied cells in excel. ...

Split Excel workbook into separate Files
split workbook into separate file3

This post will guide you how to split a large workbook to separate files and each worksheet should be saved as a single file. How do I split the whole workbook into several excel worksheets or single excel file. Assuming ...

How to Get the List of File Names From a Folder
get list of file names from a folder11

This post will teach you how to get the list of file names in a given directory to a worksheet in Excel. You will learn that how to use Excel to view Files and Folders in your worksheet by get ...

Find Duplicate Values in Two Columns
find duplicate cells in two columns111

This tutorial will show you how to find duplicate values in two given columns in Excel. Or How to compare two columns and find duplicate entries in Microsoft Excel worksheet. And you will learn two methods to compare columns so ...

Remove Leading and Trailing Spaces
remove leading and trailing spaces112

In this tutorial you will learn that how to remove leading or trailing spaces from a text string in a cell in Excel. This post will guide you how to delete leading or trailing spaces of all cells in a ...

Generate Random Passwords
generate random passwords5

This post will teach you how to quickly generate a random password with Formula in Excel. You can combine a series of worksheet functions to create a complex formula to generate a random password in Microsoft Excel. Generate Random Password ...

Sort by Second or Third character in a Column
sort string by second character13

This post will guide you how to sort text string by second or third character in a Column in Excel. You may be want to sort a string in a Cell by the Second or last character in excel, how ...

Copy a Cell to Clipboard with Single Click
copy a cell to clipboard3

This post will teach you how to use the Excel VBA macro code to copy a Cell to clipboard with only single click in Excel. How do I automatically copy the content of cell to Clipboard while clicking on the ...

How to Convert Positive Numbers to Negative
change positive to negative 112

This tutorial will teach you how to change positive numbers to negative with Paste special multiply operation in excel. How to convert positive number to negative or how to reverse the number signs with VBA code in Excel. Convert Positive ...

Combine Duplicate Rows and Sum the Values
combine duplicate rows7

This post will teach you how to combine duplicate rows and sum the corresponding values or calculate numbers in specific column in excel. And how to merge duplicate rows and then sum the values with VBA macro in Excel. How ...

Sidebar