Just a name, if you enter into Excel spreadsheet, the program has a lot of blank cells. Maybe you have amended with some copy and paste text from others or remove the row as you like it. You can go through the whole list or make individually to delete the blank row when you perform like you waste a lot of time.
You can choose some simple arrangement. All you have to load the spreadsheet that you wish to bring edit or choose every single cell. You can make faster clicking the small triangle from A column and 1 row. After that, use F5 and click the Special button to load the Go To Special menu. Choose the Blanks on the list and hit the Ok. This going to be select all the blank cells on your spreadsheet. Finally, you can give delete function on them.
Before you doing above performance, choose Home tab and see the cell section on the right side. You can click the Delete, after Delete Cells. You can choose more Delete like Sheet Rows or Sheet Columns, but some of the test failures the site MakeUseOf writer Ben Stegner pointed out. Once you approach on Delete, the Excel will ask you how to perform the deletion. Whether you delete the row, skip the Shift cells up. If you come to delete the column, use Shift cells left.
The final result, once you have done delete the blank on the spreadsheet, it keeps only the text. If you are using Google Spreadsheet, it will show all blank cells, you can copy and paste into the Excel, after that you can apply above options to delete the blank cells.
That’s it.
Via: MakeUseOf
Syed Ali Abubacker
Latest posts by Syed Ali Abubacker (see all)
More from my site
Copyright © 2017. All Rights Reserved.