Paste with number formatting and formulas intact

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 and number formatting without any other 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 and number formatting intact as shown next.

As you can see, the currency formatting is there but the background color and the thick border is not.