View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default 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?