Skip to main content

Posts

Showing posts from February, 2015

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

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about: Ctrl + " Tip Quiz What is the shortcut to erase the selected lines border of the cells? In Excel worksheet, if you want to make the copy and paste function the entered data of the above cell to the adjacent below cell. The Exceltip2day blog has already described to you the quickest ways and illustrated image for understanding and follow it by yourself. Shortcut for: To Auto fill cell values down and edit from the cells above.  Windows shortcut Ctrl   " 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. In here, it's the cell B4. πŸ‘‰  3] Press the button,  [ Ctrl ]  and [  "(Quotation mark) ] . Then, suddenly the data will appear i

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: 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. 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: 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 Unli