First paste option

On the 7th of January we mentioned we would discuss each of the options from the Clipboard paste options illustrated here:

We will being with the first option (top row, far left) and give you a brief rundown of how each of these options will paste a formula from the clipboard. To begin, we will create a very simple worksheet with column A totaled in cell A7 using the formula =Sum(A1:A5) as shown here:

 

 

We formatted cell A7 as currency, with a yellow background, and a thick border. We have selected cell D7 so the figure will show the formatting as an indication of where we are going to paste the results. Next we will reselected cell A7 and then copied it to the clipboard. To copy the cell you can use the keyboard shortcut Ctrl-C.

When we paste using the option discussed before (), we will get a straight paste, from one cell to the other, copying the formatting and the formula. When we paste into cell D7, we get the total of column D with the formatting of the cell intact as shown here:

Notice the formula can be seen in the formula bar specifying that the total is for column D. This is the same result as if you pasted using the Ctrl-V shortcut.