Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy & paste special
How would I copy & paste to a new sheet the format & formula but not the data
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy & paste special
Roger,
I assume you mean you have some cells with data and some cells with formulas, and you want to copy only those cells with formulas (plus the formatting for the whole page). The simplest way is to copy everything, and then delete the data. If the data cells and formula cells are intermingled, however, this can become time consuming. To simplify the delete task in this case, select the area of the spreadsheet that contains the data to be deleted. Then click Edit Goto Special Constants. You can uncheck "Text," etc. to more narrowly constrain what you want to delete. Then click OK. At that point, all of your formulas will have been unselected, and you can just hit the Delete key to clear the data. (That may sound a little confusing, but if you try it, it will make sense.) Tim C "Roger" wrote in message ... How would I copy & paste to a new sheet the format & formula but not the data |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy & paste special
If you want to copy over formula from one sheet to the other without linking
to the original sheet? ctrl + H, replace e = with ^=^, select the ranges you want to copy, copy and paste into the new sheet, reverse the replace and replace ^=^ with = on both sheets -- Regards, Peo Sjoblom Portland, Oregon "Roger" wrote in message ... How would I copy & paste to a new sheet the format & formula but not the data |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste Special and Paste Object | Excel Discussion (Misc queries) | |||
Macro to find, copy, and paste until value change | Excel Worksheet Functions | |||
When I special paste and transpose.... | New Users to Excel | |||
Copy and paste | Excel Discussion (Misc queries) | |||
Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) |