Sunday, February 22, 2015

Quick Way To Copy and Paste The Entered Data To The Immediate Underneath Cell | Exceltip2day Blog

In Excel worksheet, if you want to make the copy and paste function the entered data of above cell to the adjacent below cell.

The Exceltip2day blog has already described you the quickest ways and illustrated image for understanding and follow it by yourself.

Do the below steps;

1] Find the cell you want to copy. For example, you will see the image below supposing to copy the entered data from the cell B3.

2] Go to the immediate underneath cell you want to paste data into. It's the cell B4.

3] Press the button, "Ctrl" and "(Quotation mark)". Then, suddenly the data will appear in the cell B4 as the same as the data of the cell B3 above.

Do you think it is useful for you?
Michael Leng

See more other tips:
Would you like to surf more my other blogs?

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.

Micheal Leng.

See more other tips: