Thursday, February 19, 2015

Little Known Ways: Simply Deleting Cell(s) in Excel Worksheet - [Ctrl] + [-](Minus button)

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:
  1. Selecting any cell(s) to be deleted
  2. Press the keyboard button "Ctrl" and "-"(Minus button)
  3. Click to select any deleting type (Shift cells left, Shift cells up, Entire row, Entire column)
  4. Then click to “OK” button
See more images below for more clear.

Selecting the cell A5 and click Ctrl, - together 

Select one of the 4 choices above as you desired

Image of the completion after the task done.

Bye,
Micheal Leng.

See more other tips:

No comments:

Post a Comment