ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Need to copy (https://www.excelbanter.com/excel-worksheet-functions/186597-need-copy.html)

Lauri

Need to copy
 
I am constantly added worksheets to my excel file. How do I copy all info
including the column widths to another worksheet?

Dave Peterson

Need to copy
 
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.



Lauri wrote:

I am constantly added worksheets to my excel file. How do I copy all info
including the column widths to another worksheet?


--

Dave Peterson


All times are GMT +1. The time now is 09:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com