Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am using Excel 2007 and want to break up a large worksheet into many small
sheets but retain the original data in one sheet. When pasting the coipied data as a link the copied data is inserted into the new worksheet but sans the original formating such as currency, number formats, text color etc. What to do? )) many thanks |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
see response to your other posting
-- Regards Roger Govier "garwil" wrote in message ... I am using Excel 2007 and want to break up a large worksheet into many small sheets but retain the original data in one sheet. When pasting the coipied data as a link the copied data is inserted into the new worksheet but sans the original formating such as currency, number formats, text color etc. What to do? )) many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
'paste special', 'paste link' formatting transfer | Excel Discussion (Misc queries) | |||
Special paste column widths is not coming up in Excel 2007? | Excel Discussion (Misc queries) | |||
Conditional formatting -- copy paste special won't change referenc | Excel Discussion (Misc queries) | |||
Lost formatting after special paste... | Excel Discussion (Misc queries) | |||
Paste Special Formats Generated by Conditional Formatting | Excel Discussion (Misc queries) |