Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
duplicating worsheets
I have created a template that I would like to duplicate to other worksheets
in the same workbook. When I copy and paste the font size and column widths do not stay the same. How do I fix? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
duplicating worsheets
Try this:
Hold down the CTRL key Click and hold on the Tab Name of the original sheet Drag to the desired location Release the mouse button Release the CTRL key You should now have an exact copy of your original sheet, formatting and all. HTH, Elkar "Don" wrote: I have created a template that I would like to duplicate to other worksheets in the same workbook. When I copy and paste the font size and column widths do not stay the same. How do I fix? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
duplicating worsheets
Hi Don
This is prasad from India but working in Crystalgallery in Dubai (UAE) i am new person for this forum its very easy i think.. first you select that seet name means just right click it will show a small window like rename, delete, move or copy just click move or copy in the wht are the sheets available in that work book it will show at last there is a box create a copy u just click on that automatically at the end of all sheets ur requested sheet will be appear with same font and same format then u save the templet..... check and tell me u r answer ok mine id / . waiting for u r reply "Elkar" wrote: Try this: Hold down the CTRL key Click and hold on the Tab Name of the original sheet Drag to the desired location Release the mouse button Release the CTRL key You should now have an exact copy of your original sheet, formatting and all. HTH, Elkar "Don" wrote: I have created a template that I would like to duplicate to other worksheets in the same workbook. When I copy and paste the font size and column widths do not stay the same. How do I fix? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Xcl-create subsets of a set of numbers w/o duplicating the subset | Excel Worksheet Functions | |||
How can I create a pie chart without duplicating my cells? | Charts and Charting in Excel | |||
How do I stop worksheets from duplicating cell in a different wor. | Excel Discussion (Misc queries) | |||
Stop from duplicating entries on multiptle sheets | Excel Discussion (Misc queries) | |||
Sheets duplicating | Excel Worksheet Functions |