Adding 1 or more blank lines in Excel is extremely fast

Adding one or more blank lines in Excel is a simple trick every Excel user should know to be able to use this office software better. Because of that, TipsMake.com we have written this tutorial for all interested readers.

Adding 1 or more blank lines in Excel is extremely fast Picture 1

1. Insert a blank line into Excel

To insert a blank row into Excel data, you need to highlight the data line below the location where the blank line will be inserted.

Then there are two ways you can insert blank lines into that position.

The first way is that you right-click on the highlighted data line, then you will see an option display table, you select Insert to insert more rows at the selected position.

Adding 1 or more blank lines in Excel is extremely fast Picture 2

As for the second method, you can open the Home ribbon on the toolbar.

Adding 1 or more blank lines in Excel is extremely fast Picture 3

Then look to the right of the Cells section , click Insert and select Insert Sheet Rows in the drop-down list.

Adding 1 or more blank lines in Excel is extremely fast Picture 4

As you will see with the above two methods, a blank line will be inserted above the highlighted line. This line will have the same format as its top line.

Adding 1 or more blank lines in Excel is extremely fast Picture 5

2. Insert multiple blank lines into Excel

To insert multiple blank lines in Excel you can follow the same principle as inserting a single line, but the difference here is that you not only black out one line as above but you need to black out at the same time a lot. current.

The number of lines you highlight is the number of lines that will be inserted in Excel at the highlighted position.

Also with two similar methods above, the first way you can right-click on the highlighted array and then select Insert in the options panel that appears.

Adding 1 or more blank lines in Excel is extremely fast Picture 6

The second way to add more rows to Excel data is to open the Home ribbon on the toolbar and then find the Cells section of this ribbon.

Click on the Insert icon under Cells section and select Insert Sheet Rows .

Adding 1 or more blank lines in Excel is extremely fast Picture 7

After doing either of the above two methods, you will see many blank lines inserted into Excel carrying the format of the previous line.

One more thing, if you want to adjust these formats, you can click on the broom icon below the highlighted area (which is the line just added) and choose one of three options:

- Format Same As Above: The format is the same as the previous line

- Format Same As Below: The format is the same as the following line

- Clear Formatting: Delete all formats.

Adding 1 or more blank lines in Excel is extremely fast Picture 8

As the illustration below shows, the choice is for Same As Below .

Adding 1 or more blank lines in Excel is extremely fast Picture 9

Thank you for reading our article TipsMake.com on how to add 1 or more blank lines in Excel very quickly. Wish you can successfully implement this trick based on our tutorial.

5 ★ | 1 Vote

May be interested

  • Page numbering in Excel does not start from 1Photo of Page numbering in Excel does not start from 1
    excel does not split separate pages like in word, but when printed, they will need to be broken down into individual pages. and you can also number the page for excel like word, can optionally number the page from one or page numbering in excel does not start from 1.
  • Summary keyboard shortcuts in ExcelPhoto of Summary keyboard shortcuts in Excel
    summary keyboard shortcuts in excel. summing is one of the many calculations available in excel and it will serve a great deal in statistical accounting. sometimes you need to work with a lot of calculations so using keyboard shortcuts will save a lot of working time.
  • How to install and use Unikey for new usersPhoto of How to install and use Unikey for new users
    how to install and use unikey for new users. unikey is a famous vietnamese percussion with millions of installs on computers. with the advantages of compact, stable operation, unikey is an indispensable vietnamese typing tool on our pc.
  • How to convert numbers to dates in ExcelPhoto of How to convert numbers to dates in Excel
    converting digital data into dates in excel is a pretty useful trick for people who use this software. sometimes your date data cells are converted into digital data cells, then if you do not know how to turn it back into a date, please refer to the following tutorial tips of tipsmake.com .
  • How to delete Watermark, delete stamps in Word documentsPhoto of How to delete Watermark, delete stamps in Word documents
    how to delete watermark, delete stamps in word documents. watermark is stamped in the document to copyright the document. but if you do not want that watermark in your document, tipsmake.com can show you how to delete that watermark.
  • How to round up sums in ExcelPhoto of How to round up sums in Excel
    how to round up sums in excel. in fact, very often accounting work requires rounding the money. when you use an automatic calculation formula, it doesn't always produce whole numbers. however, according to monetary rules: for example, dong, the amount will be whole numbers without fractional parts.