• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

How to quickly insert one or multiple blank rows in Excel?

0 Comments

If you have entered incomplete data on Excel and don’t know how to add new blank rows in between, don’t worry. Inserting one or multiple blank rows in Excel is a simple task, but there are many ways to do it. When you add new rows in Excel, the table will include new cells to enter data. This article will guide you on how to insert one or multiple blank rows in Excel. Please follow the instructions below.

1. Inserting one blank row in Excel:

In the Excel window, you need a data table as shown below. First, you need to highlight the row below where you want to insert the blank row. We introduce you to two ways below:

Method 1: Select Insert > Shift cells down

First, right-click on the selected position. A context menu will appear on the screen. To insert a row, select the “Insert” option as shown below:

How to quickly insert one or multiple blank rows in Excel?

How to quickly insert one or multiple blank rows in Excel?

Next, select the “Shift cells down” option to insert a row above the selected position.

How to quickly insert one or multiple blank rows in Excel?

How to quickly insert one or multiple blank rows in Excel?

Press OK to complete. Then you have successfully inserted a blank row into the Excel worksheet as shown below:

How to quickly insert one or multiple blank rows in Excel?

How to quickly insert one or multiple blank rows in Excel?

Method 2: Select Home > Insert > Insert Sheet Rows

With this method, select the Home tab on the toolbar. Then, look to the right, click on the “Insert” option. Next, choose “Insert Sheet Rows” to add a row.

How to quickly insert one or multiple blank rows in Excel?

How to quickly insert one or multiple blank rows in Excel?

Then you will get the same result as shown below:

How to quickly insert one or multiple blank rows in Excel?

How to quickly insert one or multiple blank rows in Excel?

2. Inserting multiple blank rows in Excel:

To insert multiple blank rows into Excel, you perform the same actions as inserting one row. However, for this operation, you need to highlight multiple rows instead of just one. The number of rows you highlight will correspond to the number of rows added to the worksheet.

Method 1: Select Insert > Shift cells down

In the example below, we add two blank rows. You also need to highlight the rows you want, then right-click to select “Insert”.

How to quickly insert one or multiple blank rows in Excel?

How to quickly insert one or multiple blank rows in Excel?

Next, choose the “Shift cells down” option to add multiple rows.

How to quickly insert one or multiple blank rows in Excel?

How to quickly insert one or multiple blank rows in Excel?

Press OK to complete. You have now added multiple rows to the Excel worksheet.

How to quickly insert one or multiple blank rows in Excel?

How to quickly insert one or multiple blank rows in Excel?

Method 2 : Select Home > Insert > Insert Sheet Rows

With this method, you click on the Home tab on the toolbar. Then, look to the right and click on the Insert option. You will see a list of options, select Insert Sheet Rows to add more rows to your spreadsheet.

How to quickly insert one or multiple blank rows in Excel?

How to quickly insert one or multiple blank rows in Excel?

The number of rows you want to add will then be inserted into the worksheet. See the image below for a clearer view.

How to quickly insert one or multiple blank rows in Excel?

How to quickly insert one or multiple blank rows in Excel?

Guide on how to quickly insert one or multiple blank rows in Excel

In case you want to adjust the format of the inserted rows, click on the paintbrush icon at the end of the new row. You will then see the following options:

  • Format Same As Above: Format the same as the row above
  • Format Same As Below: Format the same as the row below
  • Clear Formatting: Remove all formatting.
How to quickly insert one or multiple blank rows in Excel?

How to quickly insert one or multiple blank rows in Excel?

Click on the option that you need to get the desired result.

This article has introduced how to insert one or multiple blank rows in Excel. We hope this article provides useful information for our readers. Good luck with your work.

Rate this post
28
253 Views
How to fix reverse date error in ExcelPrevHow to fix reverse date error in ExcelMarch 8, 2023
Using the IF function to quickly calculate electricity bills in ExcelMarch 8, 2023Using the IF function to quickly calculate electricity bills in ExcelNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Kaspersky Internet Security 2021 1 year 5 devices key Global Kaspersky Internet Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $45.00
  • Windows Server 2022 Datacenter Key Global Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $7.00
  • Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year
    Rated 5.00 out of 5
    $164.50
  • Avast Ultimate Suite 2021 1 Year 10 Devices Global Avast Ultimate Suite 2021 1 Year 10 Devices Global
    Rated 5.00 out of 5
    $54.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
Products
  • Microsoft Visual Studio 2022 Professional Key Microsoft Visual Studio 2022 Professional Key $19.00
  • Buy Windows Server 2016 Essentials Key Global Buy Windows Server 2016 Essentials Key Global
    Rated 4.75 out of 5
    $10.00
  • Windows Server 2019 Standard Key Global Windows Server 2019 Standard Key Global
    Rated 4.68 out of 5
    $7.00
  • Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year $284.73
  • Microsoft Office Professional Plus 2010 retail Microsoft Office Professional Plus 2010 retail Key Global - 5 PC
    Rated 4.96 out of 5
    $15.00
  • Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account
    Rated 4.71 out of 5
    $99.00
  • Microsoft Visual Studio Enterprise 2019 For 1 PC Microsoft Visual Studio Enterprise 2019 For 1 PC
    Rated 4.88 out of 5
    $15.00
  • Office 2019 Professional Plus Key Global Bind to your Microsoft Account Office 2019 Professional Plus Key Global Bind to your Microsoft Account
    Rated 4.97 out of 5
    $49.00
  • SQL Server 2019 Standard SQL Server 2019 Standard $20.00
  • microsoft office home and business 2019 pcmac key Microsoft Office Home And Business 2019 (MAC) key bind to your Microsoft account
    Rated 4.95 out of 5
    $30.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.