Please take note that this method is worked for the only column that has every cell through out it containing data entering. If there is any empty cell (blank cell) between them, this Excel trick will only work for until the last cell, which the adjacent column has the data entering inside the active cell then it will stop.
If you want to resume the this method again for the rest cells. Just double click on the fill handle, the small black square again. Keep doing like this once encounter such as the same kind of problem.
For example [see the image below], supposing we are going copy data from column “J” and then to paste into column “K”
Trick methods how to copy and paste:
- Click in cell “K1” and fill out the “=”[equal] in it.
- Move cursor to click in cell “J1” and press the “Ctrl” and “Enter” buttons on your keyboard. After that the cursor will active in cell “K1”
- Move cursor to the square in the lower right-hand corner of the cell “K1” until the small black square appearing.
- Double click the fill handle (the small black square as shown as the action of the step no. 3 on above.).
The result should come out something like all the data entering (formula) in the entire active cells in column “J” already copying to column “K”.That’s all done.
Benefits:
Free from mouse using.See more:
Easy way method.
Save time.
Can comply for other function.
Find the empty cell(s) in the origin column.
- Shortcut Excel Minimize and Maximize all Spreadsheet in a Workbook
- 2 More Alternative Shortcut Tricks Minimize and Maximize Excel Workbook
- How To Find Data In A Range of Specific Cell Of Excel Spreadsheet
- Turn Off / Turn On Scroll Lock Excel Tip To Lock & Unlock On Keyboard
Comments
Post a Comment