G
Gary
Can I copy ALL formats from one worksheet to another, especially including
cell width?
cell width?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Pete
If you copy the sheet into the same workbook then all formats will be
preserved - the easiest way I find is to select the worksheet you want
to copy, then hold the CTRL key down while you drag the worksheet tab -
a small black arrow will indicate where the new sheet will be copied
to, and release CTRL when you have it positioned correctly. A " (2)"
will be added to the original worksheet's name (or " (3)", or " (4)"
etc depending how many copies you make).
Of course, you may need to remove data and formulae from the copied
sheet.
Hope this helps.
Pete
preserved - the easiest way I find is to select the worksheet you want
to copy, then hold the CTRL key down while you drag the worksheet tab -
a small black arrow will indicate where the new sheet will be copied
to, and release CTRL when you have it positioned correctly. A " (2)"
will be added to the original worksheet's name (or " (3)", or " (4)"
etc depending how many copies you make).
Of course, you may need to remove data and formulae from the copied
sheet.
Hope this helps.
Pete
S
ScottO
If you click on the Select All area (the little grey square to the
left of ColA and above Row1), then the whole sheet will be selected.
If you copy and then go to your other sheet, select A1 and Paste
Special > Formats, then it's done.
Rgds,
ScottO
| If you copy the sheet into the same workbook then all formats will
be
| preserved - the easiest way I find is to select the worksheet you
want
| to copy, then hold the CTRL key down while you drag the worksheet
tab -
| a small black arrow will indicate where the new sheet will be
copied
| to, and release CTRL when you have it positioned correctly. A "
(2)"
| will be added to the original worksheet's name (or " (3)", or "
(4)"
| etc depending how many copies you make).
|
| Of course, you may need to remove data and formulae from the copied
| sheet.
|
| Hope this helps.
|
| Pete
|
left of ColA and above Row1), then the whole sheet will be selected.
If you copy and then go to your other sheet, select A1 and Paste
Special > Formats, then it's done.
Rgds,
ScottO
| If you copy the sheet into the same workbook then all formats will
be
| preserved - the easiest way I find is to select the worksheet you
want
| to copy, then hold the CTRL key down while you drag the worksheet
tab -
| a small black arrow will indicate where the new sheet will be
copied
| to, and release CTRL when you have it positioned correctly. A "
(2)"
| will be added to the original worksheet's name (or " (3)", or "
(4)"
| etc depending how many copies you make).
|
| Of course, you may need to remove data and formulae from the copied
| sheet.
|
| Hope this helps.
|
| Pete
|