How to delete blank lines in Excel

Who I am
Valery Aloyants
@valeryaloyants
Author and references



Preliminary information


Before proceeding and explaining yourself how to delete blank lines excel, there are some details you need to be aware of.


In fact, you need to know that there is a difference between delete and eliminate one row, as both options are agolable in Excel. Delete a line means to remove all the contents of the row on which the action is applied. By doing so, however, the row still remains in the Excel sheet (despite being empty). What you need, however, is delete a row: in fact, by doing this, the row is completely removed from the Excel sheet.

Deleting a blank row is useful for making an Excel sheet more compact and tidy, because doing so avoids unnecessary empty spaces. It can also be essential when you want to remove a row containing information that is no longer relevant: by deleting it, the sheet will go back to being as it would have been before containing that row, without changing the rest (even if some links could "skip" of any formulas related to specific cells, so I advise you to check all the values ​​well after deleting rows from Excel). That said, let's take action!


How to delete blank lines in Excel on PC


Per delete a blank row in Excel, the first thing you need to do is open the sheet from which the row is to be deleted.

Once this is done, find the row that is too many and right click on number assigned to the row, which you can find on the left of the worksheet. This will open a small menu: then click on the option Delete and that's it, the row has been removed from the sheet. In its place, all content that was below it is brought up one line.

If you want delete more than one row at a time, you have to select them all together. To do this, press on the first line from which you want to start the deletion, then select the green box that appears on the screen and drag it up or down, depending on which lines you want to select.

In case you want delete multiple blank lines that are not connected to each other, click on the lines in question while holding down the key Ctrl on the keyboard (or the cmd on Mac) and then click on them. By doing this, you will be able to select multiple rows at a time, even if they are not arranged one after the other.


Per delete blank Excel lines from the keyboard, if you are using Windows, you can use a special shortcut. All you have to do is select the row or rows you want to delete and then press Ctrl + -.

If you want instead delete blank lines in Excel on Mac, the process is the same as in Windows, but with the only difference that the shortcut to use is different. For Mac, in fact it is cmd + -.

That's all: easy, right? Deleting a row in Excel is really a simple process and as you have seen, it only takes a few clicks.


Delete all blank lines in Excel

If you need to delete all blank lines present in the middle of your Excel sheet, know that I have the solution to that too.

The first thing you need to do is select the column where the blank lines you are trying to delete are contained. At this point, press on the tab Home, top left, and then press the button Find and select, located at the top right. From the menu that is proposed to you, click on the option go: by doing so, a new window appears, in which you have to click on the button Analysis.


From the window you just opened, you can see the elements that you can select to perform multiple actions at once, simply by choosing the desired option. What interests you, in this case, is the one called Empty cells: select it and then press the button OK.

When you have finished this process, you will be able to see that all empty rows present in the column you chose at the beginning will be selected. Before deleting them, make sure that only the rows that you actually want to get rid of have been selected.

All you have to do now is right-click on one of the selected lines and then, from the menu that is proposed, click on the item Delete.

After running the comme, in this case, the rows are not deleted immediately. In fact, before this happens, a window will appear, in which you will be asked what action you want to perform exactly. Then select the option Whole row and click on your tasto OK, to confirm.

By doing so, the game is done: all the empty lines present in the written part of the sheet will be disappeared.

Delete blank Excel rows at the bottom

How do you say? Are you trying to delete blank lines at the bottom of the sheet of work? Then know that the procedure you have to follow is slightly different than the one illustrated above, but still simple. However, keep in mind that it is not possible to actually delete the rows, as they will reappear automatically. It is possible, however, to hide them, so that they are not in the way.

To get started, what you need to do is select all the blank lines. Don't worry, you don't have to do it manually! Just select the first blank line from which you want to start deleting the others. Once this is done, you need to type the following key combination: Ctrl + Shift + down arrow if you are using Windows; control + shift + down arrow if you are using macOS.

The key combination just performed is used to select all the lines in a document starting from the first selected line. At this point, to hide them, you have to right click on one of the selected lines; then, from the menu that is proposed to you, click on the option Hide. Now all lines have been hidden.

Per restore them, tap on the tab Home, top left, and then, in the group Rooms go up Format> Hide and Unhide> Unhide Lines. By doing so, all hidden rows in the sheet in question will be visible again.

How to delete blank lines in Excel online

You are using the Microsoft's online version of Excel and don't know how to delete blank lines? Then know that the procedure is very similar to that seen above for the desktop version of the program.

The interface of this version of Excel, in fact, is almost the same as that of Excel for Windows and macOS. The differences are almost purely aesthetic, e, in fact, the functionality and controls of the two versions are practically the same.

Start, then, by opening the sheet from which you want to delete the empty lines (or load it from your PC, by clicking on the appropriate item on the home page of the service). At this point, select the line or lines you want to delete, by clicking on them, and right-clicking on one of the selected ones. From the menu that is proposed to you, select the item Delete lines And that's it.

Per delete blank lines with the keyboard via a combination of keys, here too you can use the same one used for the version of Excel for Windows and macOS. Then select the blank lines you want to delete and then type the combination Ctrl + - on Windows or cmd + - on macOS and the cells will be deleted.

How to delete blank lines in Excel on smartphones and tablets

You are using Excel per Android o iOS / iPadOS and need to delete blank lines from a spreadsheet? No problem, you can also do it from smartphones and tablets.

Before explaining how, however, there are a few things I need to make you aware of. In fact, I start by telling you that the Excel interface for mobile devices is different from that on a PC, especially if you are using Excel on a smartphone. In fact, if you are using a mobile phone, the menu is located at the bottom of the screen. If, on the other he, you are using it on a tablet, the interface is more similar to that for a PC, with the menu located at the top of the screen.

In any case, although the Excel interface on mobile devices is more or less different from that for PC, the procedures to follow to eliminate blank lines are still very simple, so just keep reading to find out how to do it.

First, then, open the sheet from which you want to delete blank rows. Once this is done, you need to select the lines in question. To do this, simply press on the lines you want to delete. For select more than one row, you must first press on the starting line and then drag the white dot which appears in the center of the selected row up or down, depending on which rows you want to select.

When you have selected all the lines you want to get rid of, you should have noticed that a little appeared above the selected lines horizontal menu: At this point, press it and swipe right, until you see the option Delete, which you must select. That's all: the lines you selected are now gone!



Audio Video How to delete blank lines in Excel
add a comment of How to delete blank lines in Excel
Comment sent successfully! We will review it in the next few hours.