Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Export data saving page set ups
I would like to export the existing data in a worksheet to another one
retaining only formats, values and page layouts. The solution I found for formats and values is to use the past special function twice, one for formats, one for values. How do I export the page set ups? Is there a command I am not familiar with, a macro perhaps? Thanks PiPPo |
#2
|
|||
|
|||
PiPPo
Instead of copying the data, copy the sheet then select the cells on the copied sheet and copypaste values. How to............ Right-click on the sheet tab and "move or copy". Select "create a copy" and point to where you want it copied. Page setup will be copied also. Gord Dibben Excel MVP On 14 Oct 2005 08:50:27 -0700, "PiPPo" wrote: I would like to export the existing data in a worksheet to another one retaining only formats, values and page layouts. The solution I found for formats and values is to use the past special function twice, one for formats, one for values. How do I export the page set ups? Is there a command I am not familiar with, a macro perhaps? Thanks PiPPo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking changing data | Excel Discussion (Misc queries) | |||
Sorting Data that feeds into other formulas.... | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Can Excel Export Data to Word Format? | Excel Discussion (Misc queries) | |||
export excel to Front Page | Excel Discussion (Misc queries) |