ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   copy & paste (https://www.excelbanter.com/new-users-excel/70421-copy-paste.html)

Roger

copy & paste
 
How would I copy & paste to a new sheet the format & formula but not the data


George

copy & paste
 
Roger wrote:
How would I copy & paste to a new sheet the format & formula but not the data

Its probably easier to copy it all then use EDIT/GOTO (Ctrl-G)
The click on SPECIAL and select CONSTANTS then OK

and finally press DELETE

George


All times are GMT +1. The time now is 12:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com