This is a great Excel shortcut to copy cell formatting or values on the fly. Here’s how it works:
Select the source cell or range. Then, right-click the cell border and drag it to the target cell. When you release the mouse, Excel gives you a menu of choices. Pick the one you want, liks Choose Copy Here As Formats Only or Copy Here as Values Only and voila! Quick and easy!