Rich
Right-click on sheet tab and "Move or Copy"
Click "create a copy" and select where you want it to go.
Note: you can copy row heights if you select the entire rows, not just the
cells in those rows.
Gord Dibben MS Excel MVP
On Thu, 3 May 2007 15:21:01 -0700, Rich <(E-Mail Removed)> wrote:
>Thanks. I can handle doing it in VBA. My issue was that if I wanted to
>retain column widths, row widths, ... With the gui PasteSpecial I can select
>ColumnWidths, and it will copy the column widths but not the data. And I did
>not see anything in the gui for copying row widts.
>
>I guess I should really as -- how to copy an Excel Sheet to a new Excel
>Sheet (or to another workbook) and keep everything intact. I know there is a
>way to do this through the gui - I just can't remember how to do it.
>
>
>"Jim Jackson" wrote:
>
>> In VBA
>>
>> Range("A1:Z600").Copy
>> Workbooks(wbk2).Activate
>> Sheets("Sheet1").Range("A1").PasteSpecial xlPasteFormats
>> Sheets("Sheet1").Range("A1").PasteSpecial xlPasteFormulas (or xlPasteValues)
>> --
>> Best wishes,
>>
>> Jim
>>
>>
>> "Rich" wrote:
>>
>> > How do you copy an Excel sheet to another sheet - or create a new worksheet
>> > and use the same formatting as another sheet? Like sheet 1 columns A-M are
>> > .5 width. How can I copy the contents of sheet1 to Sheet2 and preserve the
>> > formatting in sheet1?
>> >
>> > Thanks,
>> > Rich
|
Similar Threads
