Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy a sheet with all formats - column widths, etc?
I need to copy a worksheet several times within a workbook. But when I
select a worksheet and paste it into a new worksheet, I lose most of the formatting, like colum/row widths. Is there a way to copy a worksheet within a workbook or turn a worksheet into a new worksheet? The only way I can see to do this right now is to create a copy of the workbook. But I need the new sheets inside the same workbook. The only other thing I can think of is to create the new worksheets with vba, but that would be quite tedious as I have several formats. Is there a simpler way? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy a sheet with all formats - column widths, etc?
Hi there,
How about right clicking the sheet tab and selecting Move or Copy, check Create Copy..? Would that not work for you? If not, I have misunderstood your query. Regards, Zack Barresse "Rich" wrote in message ... I need to copy a worksheet several times within a workbook. But when I select a worksheet and paste it into a new worksheet, I lose most of the formatting, like colum/row widths. Is there a way to copy a worksheet within a workbook or turn a worksheet into a new worksheet? The only way I can see to do this right now is to create a copy of the workbook. But I need the new sheets inside the same workbook. The only other thing I can think of is to create the new worksheets with vba, but that would be quite tedious as I have several formats. Is there a simpler way? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy a sheet with all formats - column widths, etc?
Thanks. Yes. That did the trick. It never occured to me to look at all the
options on the context menu. "zackb" wrote: Hi there, How about right clicking the sheet tab and selecting Move or Copy, check Create Copy..? Would that not work for you? If not, I have misunderstood your query. Regards, Zack Barresse "Rich" wrote in message ... I need to copy a worksheet several times within a workbook. But when I select a worksheet and paste it into a new worksheet, I lose most of the formatting, like colum/row widths. Is there a way to copy a worksheet within a workbook or turn a worksheet into a new worksheet? The only way I can see to do this right now is to create a copy of the workbook. But I need the new sheets inside the same workbook. The only other thing I can think of is to create the new worksheets with vba, but that would be quite tedious as I have several formats. Is there a simpler way? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying formats - column widths, formats, outlining to worksheets | Excel Worksheet Functions | |||
How to copy & paste row heights and column widths to another page | Excel Discussion (Misc queries) | |||
Can a column have different widths on the same sheet? | Setting up and Configuration of Excel | |||
how do I copy multiple column widths from a worksheet in one work. | Excel Discussion (Misc queries) | |||
how to copy sheets keeping defined column widths | Excel Worksheet Functions |