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;
See more other tips:
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
- Little Known Ways: Simply Deleting Cell(s) in Excel Worksheet - [Ctrl] + [-](Minus button)
- 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"]
- How To Align Number To Be At The Center Of Active Cell(S) In Excel's Workbook
- How To Escape Away From “Header And Footer” To "Normal View" | Exceltip2day
- Technical Tip To Select Or Copy Data Entered Between Range Of The Particular Cells And Uppermost Cell (A1)
- How To Display The Data Entry In All Empty Cells On The Left Of Pivot Table
- Quick And Easy Way To Paste Data To Multiple Cells In An Excel Worksheet
- [Resolve] Excel – Why Can't I See The "0" In My Excel Workbook?
- Excel Trick to Make a New Unconventional Graph with “REPT ( )” Formula
No comments:
Post a Comment