Need to copy

L

Lauri

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
VBA - retrieve data on last create named range from previous inserted named range 0
Mapping integers to strings 5
copy row high 1
Excel 2007 Move or Copy worksheet 2
Nesting more than 7 IF statements (Excel 2003) 7
Copy cells in Excel 1

Top