Excel - pasting into already formatted columns

Hi,

Why when I paste from Sheet A (unformatted), into Sheet B custom formatted on column C), the original values from A do not modify into the custom formats on B?

Is this possible, and if so, how is it accomplished?

Thank you
tahirihAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Hello,

use Paste Special - Values or for formulas Paste Special - Formulas.

Then the format will not be overwritten.

cheers, teylyn
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
You can also right-click the target cells and use the Paste Options in the context menu. The screenshot is from Excel 2010. When you hover over the options, it will display what the result will look like in the sheet.


PasteOptionsContextMenu.png
0
 
tahirihAuthor Commented:
Thank you
0
All Courses

From novice to tech pro — start learning today.