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 / 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 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 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 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 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 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 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 Ferreira
How to customize an Excel spreadsheet