Paste with formula or value without formatting

On the 7th of January we mentioned we would discuss each of the options from the Clipboard paste options illustrated here. The option we are going to explain today is indicated with the arrow.

This icon represents pasting just the formula or value in the cell without any formatting.

To begin, we will create a very simple worksheet with column A totaled in cell A7 using the formula =Sum(A1:A6) 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 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 the results with the formula but no formatting as shown next.

As you can see, a total is now in cell A7 but the background color, thick border, and currency formatting is not.