Now the cells that contain data are de-selected, and the blank cells are selected, as shown below. Step 4: After the Go To Special dialog opens, select the Blanks option and click OK. Step 3: Press the F5 key on your keyboard to bring up the Go To dialog, and then click Special.Īlternatively, you can select the Home tab on Excel ribbon, click Find & Select, and then click Go To Special. Step 2: Select the area that contains the blank cells, rows, or columns you want to delete. How to quickly delete blank cells, rows, and columns in Excel 2016 Now, this post will show you how to do that with Excel 2016. Actually, you can quickly delete all blank rows, columns, and cells in Excel at once. However, when one Excel sheet contains a large number of blank cells, deleting them one by one will be a big deal and very time-consuming. Our usual practice is to right click on this blank row/column/cell and then select Delete. It’s easy to delete one blank row, column, or cell in an Excel worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |