To copy and paste in Excel while preserving formatting, use Paste Special instead of standard paste. After copying your cells (Ctrl+C), right-click the destination and select "Paste Special," or use ...