Copy Excel sheet with formulas

while copying to source file , you can use hot keys like

Alt+E+S

+V -----Paste only the values (not the formulas).
+F------- Paste only the formulas as entered in the formula bar.
+R------Paste only formulas and number formats from copied cells.

1 Like