Forum Discussion

bikequipsteve's avatar
bikequipsteve
Copper Contributor
Apr 12, 2023
Solved

Create New Worksheet using Copy and Paste - Formulae only NOT data

Hi, first post on here so please be gentle and yes, I have searched the archive (and the web).   I am using a MacBook Pro (Ventura 13.1) and Excel for Mac v16.71 on a 365 business subscription.   ...
excel
Formulas and Functions
office 365
  • Sekoleyte's avatar
    Sekoleyte
    Apr 12, 2023

    bikequipsteve 

    Hi there. If you want to copy only formulas instead of constant data, you can delete constants after you copy all. So copy all sheet and then select all of your copied data which includes formulas and constants.

    Then Find&Select and Go to special. Then choose constants and delete them. And you can fill those cells to see which data you delete. You can see detailed screen shots below respectively.

     

    and you can delete them.

Sekoleyte's avatar
Sekoleyte
Iron Contributor
Apr 12, 2023

bikequipsteve 

Hi there. If you want to copy only formulas instead of constant data, you can delete constants after you copy all. So copy all sheet and then select all of your copied data which includes formulas and constants.

Then Find&Select and Go to special. Then choose constants and delete them. And you can fill those cells to see which data you delete. You can see detailed screen shots below respectively.

 

and you can delete them.

bikequipsteve's avatar
bikequipsteve
Copper Contributor
Apr 12, 2023
Hi, that's great - all done .. thanks very much!

Steve B
  • Sekoleyte's avatar
    Sekoleyte
    Iron Contributor
    Apr 12, 2023
    You're welcome. Glad to help.

Resources