Question: how to copy and paste all formulas and formatting in excel?
Answer: Select the cell with the formula you want to copy. Press. + C. Click the cell where you want to paste the formula. ...  To quickly paste the formula with its formatting, press + V. ...  Clicking the arrow gives you a list of options.