Rows in Excel Archives

How to Select a Row in Excel (9 Methods)

Jul 24, 2024

Method 1 - Clicking on Row Number The simplest way to select a row in Excel is by clicking on the row number you want to select. ...

How to Select a Row in Excel (9 Methods)

Insert Row in Excel After Every Row and for Table: 8 Methods

May 24, 2024

Method 1 - Using Keyboard Shortcut Select row 7 and then press ALT+I+R. A new row has been inserted into your Excel sheet. You can use ...

Insert Row in Excel After Every Row and for Table: 8 Methods

Move Rows in Excel (All Things You Need to Know)

Nov 11, 2025

In this article, we will learn how to move contiguous and non-contiguous rows or columns by using the Excel features and formula. The ability to ...

Move Rows in Excel (All Things You Need to Know)

Row Height Excel (All Things You Need to Know)

Jul 16, 2024

Here's a basic overview of selecting a row header to see its height. Download the Practice Workbook Row Height Excel.xlsx ...

Row Height Excel (All Things You Need to Know)

How to Get Excel Row Number? (8 Practical Examples)

Nov 11, 2025

Row numbers act as reference points for conducting calculations in Excel. They help users to identify and locate particular rows in a worksheet. Row ...

How to Get Excel Row Number? (8 Practical Examples)

How to Expand or Collapse Rows with the Plus Sign in Excel – 4 Easy Methods

Aug 3, 2024

The following dataset contains the sales for the months of March and April of 2022. Method 1 -Using the Group Feature to Expand or ...

How to Expand or Collapse Rows with the Plus Sign in Excel – 4 Easy Methods

How to Create Collapsible Rows in Excel (4 Methods)

Jul 3, 2024

The following Item Price List table shows the Month, Item, and Price columns. We will collapse the rows of this table. Method 1 - Creating ...

How to Create Collapsible Rows in Excel (4 Methods)

How to Expand and Collapse Rows in Excel – 2 Steps

Aug 4, 2024

Step 1 - Collapse Rows in Excel Group your dataset. You can either use an auto outline (with subtotal rows) or group rows manually. Steps ...

How to Expand and Collapse Rows in Excel – 2 Steps

How to Create Rows within a Cell in Excel (3 Methods)

Jun 16, 2024

Let’s introduce today’s dataset where the Names of some employees are provided along with their corresponding States and E-mails (inserted ...

How to Create Rows within a Cell in Excel (3 Methods)

How to Resize All Rows in Excel (6 Methods)

Jun 17, 2024

The datasheet below shows Subject Codes, Subject Names, and the number of Students in the departments. The Subject Code (cell B4) and the ...

How to Resize All Rows in Excel (6 Methods)

Hide Rows in Excel Using Shortcuts, Commands and VBA

Jul 5, 2024

Method 1 - Use Format Menu to Hide Rows Click on the row number of a row >> Drag down the cursor or hold the SHIFT key to select ...

Hide Rows in Excel Using Shortcuts, Commands and VBA

How to Color Alternate Rows in Excel (8 Ways)

Nov 11, 2025

For decorating a dataset, you can color alternate rows in Excel. In this article, you will get to know several easiest and shortest methods to do ...

How to Color Alternate Rows in Excel (8 Ways)

How to Lock Rows in Excel (6 Easy Methods)

Jun 14, 2024

The dataset we are using to lock rows contains some products and their prices and percentage of value-added tax (VAT). Method 1 - Lock ...

How to Lock Rows in Excel (6 Easy Methods)

How to Delete Rows in Excel: 7 Methods

Jul 7, 2024

This article will show seven effective techniques to delete rows in Excel, with examples and illustrations. Download the Practice Workbook In ...

How to Number Rows in Excel (9 Simple Methods)

Nov 11, 2025

In Excel, you may come across repetitive tasks often. To number rows is one of these tasks which can be a time-consuming one. There are several ways ...