Copy & Paste Formula Without Changing Format in Excel First, select the data you want to copy (C2.C7), then right-click it, and from the drop-down menu choose Copy (or use CTRL + C shortcut). Then, select the range to paste without formatting, right-click on it, and in the drop-down menu click on Paste Special.