Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to maintain row & column formatting when copying to a new work
First off I thnk the Office 2007 Excel Workbook is somehow damaged because it
keeps doubling the size of the file each time we open and close it. Its now up to 48mb and I know its not that large of a file. What I want to do is copy a range of cells A1 thru N175 over to a new workbook. I would like to maintain the cell and column formatting in the process. I don't want to have to keep rearranging the column widths each time I do this. Pershaps I need to protect something first. Anyway how does one copy a specific or even a subset of cells over to a new workbook and yet maintain any fomatting and formulas. Fortnunately this is mostly text so I don't have to worry about formulas. However I would like to save the new workbook in Excel 2003 format or even paste directly from a read only copy of the 2007 workbook over to the 2003 workbook. Thanks -- Never enough time to do it right but always enough time to do it over again and again. Especially in Windows. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to maintain references when copying lookup formula | Excel Worksheet Functions | |||
How do I maintain row heights when copying and pasting | Excel Discussion (Misc queries) | |||
column to column conditional formatting won't work, need formula | Excel Worksheet Functions | |||
copying conditional formatting to an entire column | Excel Discussion (Misc queries) | |||
COPYING CONDITIONAL FORMATTING TO A COLUMN | Excel Worksheet Functions |