Let’s come together to see the simple task but it’s very beneficially for everybody who uses Excel office or love to learn more new way to deal with it.
Here I am going to tell you how to delete empty cell(s) or cell(s) with the data entered.
Do the following:
Bye,
Micheal Leng.
See more other tips:
Here I am going to tell you how to delete empty cell(s) or cell(s) with the data entered.
Do the following:
- Selecting any cell(s) to be deleted
- Press the keyboard button "Ctrl" and "-"(Minus button)
- Click to select any deleting type (Shift cells left, Shift cells up, Entire row, Entire column)
- Then click to “OK” button
See more images below for more clear.
%2BIn%2BExcel%2BWorksheet.png) |
| Selecting the cell A5 and click Ctrl, - together |
%2BIn%2BExcel%2BWorksheet01.png) |
| Select one of the 4 choices above as you desired |
%2BIn%2BExcel%2BWorksheet001.png) |
| Image of the completion after the task done. |
Micheal Leng.
See more other tips:
- How To Use "Select Object" Selecting All The Rectangular Region Of Pictures And Deleting
- How To Format The Entire Cells In A Workbook With Just Only A Single Click
- Trick To Copy With “Format Painter” With A Single Click But Unlimited Multiple Paste
- Compare Percentage Result Between Excel Formula [Average] And [Averageif Exclude "0"]
Comments
Post a Comment