How to Delete All Blank Lines in Excel at Once | Productivity

Erasing blank lines in Excel is useful for when you copy data from another program and your spreadsheet has several empty spaces. The "Go to Special" function within the "Find & Select" menu allows you to delete all useless lines at once without selecting one by one. See in the following tutorial how to delete all blank lines that are not being used in your spreadsheet.

Remember that Microsoft Excel, belonging to the Office Package, a very famous spreadsheet editor and used in desktops and study. Therefore, knowing the most basic or advanced formulas and functionalities is a differential.

Seven Excel Functions Little People Know

Deleting all blank lines in Excel can make your work faster Photo: Divulgao / MicrosoftDeleting all blank lines in Excel can make your work faster Photo: Divulgao / Microsoft

Deleting all blank lines in Excel can make your work faster Photo: Divulgao / Microsoft

Want to buy a cell phone, TV and other discounted products? Meet the Compare dnetc

Step 1. First, you must fill in or open a pre-populated table in Excel. To open a blank worksheet, select New> Blank Workbook. You can also load a pre-filled spreadsheet. Go to Open> Browse, then open the File Pane. Search for an existing Excel document and click Open.

Create a new file or open an existing Excel file Photo: Playback / Gabrielle FerreiraCreate a new file or open an existing Excel file Photo: Playback / Gabrielle Ferreira

Create a new file or open an existing Excel file Photo: Playback / Gabrielle Ferreira

Step 2. After your spreadsheet is open and filled, go to the Home bar at the top of the screen. Look for the Find & Select option in the upper right corner of the page.

The localization feature allows the user to automatically select multiple cells Photo: Playback / Gabrielle FerreiraThe localization feature allows the user to automatically select multiple cells Photo: Playback / Gabrielle Ferreira

The localization feature allows the user to automatically select multiple cells Photo: Playback / Gabrielle Ferreira

Step 3. Select the Find & Select option, then click Go To Special ….

Inside the find box are some of Excel's special features. Photo: Reproduction / Gabrielle FerreiraInside the find box are some of Excel's special features. Photo: Reproduction / Gabrielle Ferreira

Inside the find box are some of Excel's special features. Photo: Reproduction / Gabrielle Ferreira

Step 4. By selecting Go To Special …, a window will open. In the window select the option Blank. Click on OK.

Among the options is the option to select all white cells Photo: Reproduction / Gabrielle FerreiraAmong the options is the option to select all white cells Photo: Reproduction / Gabrielle Ferreira

Among the options is the option to select all white cells Photo: Reproduction / Gabrielle Ferreira

Step 5. Excel automatically select all blank cells. In the Home bar, look for the Delete option in the Cell group.

Delete all blank rows from spreadsheet at once Photo: Reproduction / Gabrielle FerreiraDelete all blank rows from spreadsheet at once Photo: Reproduction / Gabrielle Ferreira

Delete all blank rows from spreadsheet at once Photo: Reproduction / Gabrielle Ferreira

Step 6. Select the Delete option, then go to Delete Spreadsheet Rows.

Selecting the option to delete all rows that have blank cells will be deleted. Photo: Playback / Gabrielle FerreiraSelecting the option to delete all rows that have blank cells will be deleted. Photo: Playback / Gabrielle Ferreira

Selecting the option to delete all rows that have blank cells will be deleted. Photo: Playback / Gabrielle Ferreira

Step 7. The blank lines of the spreadsheet have been deleted. Now just save or continue the project.

The blank lines have been deleted and the user can finish the project or continue editing. Photo: Reproduction / Gabrielle FerreiraThe blank lines have been deleted and the user can finish the project or continue editing. Photo: Reproduction / Gabrielle Ferreira

The blank lines have been deleted and the user can finish the project or continue editing. Photo: Reproduction / Gabrielle Ferreira

How to customize an Excel spreadsheet

How to customize an Excel spreadsheet