Excel Tips, Tricks, and Shortcuts

Trick to copy formula, text, number and any data entering from the current active column to the next adjacent column whether it is on the left or right side. 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 keyb...