{"id":1576,"date":"2021-12-14T20:38:24","date_gmt":"2021-12-14T20:38:24","guid":{"rendered":"https:\/\/www.bjorn-meijer.nl\/?p=1576"},"modified":"2022-11-16T10:33:02","modified_gmt":"2022-11-16T10:33:02","slug":"lege-rijen-verwijderen-in-excel","status":"publish","type":"post","link":"https:\/\/www.bjorn-meijer.nl\/en\/2021\/12\/14\/delete-blank-rows-in-excel\/","title":{"rendered":"Delete empty rows in Excel"},"content":{"rendered":"

Suppose you have a long list of data that contains a number of empty rows or cells. The empty rows can be easily removed from the list using the following steps.<\/p>\n\n\n\n

Step 1<\/h2>\n\n\n\n

Select the range of data that contains the blank rows or cells.<\/p>\n\n\n\n

Step 2<\/h2>\n\n\n\n

Press the F5 key (Go to). The window below will then appear.<\/p>\n\n\n\n

\"Go<\/figure>\n\n\n\n

With the F5 key (Go To) you can quickly highlight certain cells in the worksheet to perform special operations with them. This is what we're going to do.<\/p>\n\n\n\n

Step 3<\/h2>\n\n\n\n

Press the button Special<\/strong> or use key combination Alt+S<\/strong> then the following window appears.<\/p>\n\n\n\n

\"Select<\/figure>\n\n\n\n

Select the option Empty values<\/strong> or use the key combination Alt+L<\/strong>. Then click on the button OK<\/strong> to select the empty rows or cells.<\/p>\n\n\n\n

Step 4<\/h2>\n\n\n\n

click on Ctrl+-<\/strong> then the following window appears.<\/p>\n\n\n\n

\"Delete<\/figure>\n\n\n\n

Select the option whole row<\/strong> or use key combination Alt+r<\/strong>. Then click on the button OK<\/strong> after which all empty rows or cells will be deleted.<\/p>\n\n\n\n

In the video below you can see all the steps in succession.<\/p>\n\n\n\n

\n