L Lauri May 7, 2008 #1 I am constantly added worksheets to my excel file. How do I copy all info including the column widths to another worksheet?
I am constantly added worksheets to my excel file. How do I copy all info including the column widths to another worksheet?
D Dave Peterson May 8, 2008 #2 Don't insert a new sheet. Just copy the sheet you like best. Select the worksheet. Edit|Move or copy sheet (check copy!) and put it where you like it. Then rename the new sheet and clean up the junk you don't like. You can also ctrl-click on the worksheet tab and drag it to a new position to copy that sheet.
Don't insert a new sheet. Just copy the sheet you like best. Select the worksheet. Edit|Move or copy sheet (check copy!) and put it where you like it. Then rename the new sheet and clean up the junk you don't like. You can also ctrl-click on the worksheet tab and drag it to a new position to copy that sheet.