Excel Tutorial | Copy Excel Sheet To Another Excel File Without Losing Formatting Or Layout.

I want to share with you a question from a subscriber. How to copy a worksheet It is going back to basics. They needed to take one worksheet from a sales workbook and create another workbook with just that one worksheet. They previously had been making a copy of the workbook and then deleting the extra unnecessary worksheets they did not need.

There is a quick and easy way to do this:-

Right Click on the Worksheet Tabs
Select Move Or Copy
In the Drop Down selection box select (new book)
Tick the Create A Copy to copy the worksheet to a new workbook
Hit Ok.

Join thousands of other Excel users who have already joined the Excel At Excel Monthly Newsletter. 3 FREE Excel Tips every month. Plus FREE 30 Tips EBook.

Be Social & Let's Connect

Keep Excelling!.

[emalynudtujan]

How to remove the data without loosing the formula?

[salehaabbasi]

Great, short and precise and to the point. Exactly what I was looking for.
Thank you

[LelasMum]

That was terrific. Quick and exactly what I needed. Thank you!

[GiselleLoayza]

Amazing! Just what I needed! Thank you 😊

[mohammedhabeebrazanoorie]

Thanks 👍 a lot Mam it's work and I was searching for a long time I could meet such in detailed highly appreciated 👍 good job keep it up ❤

[mikeaustin]

THANK YOU! Been trying to figure this out for some time now.

[sarahmyk]

Perfect tutorial. Explained very well and was easy to visually see the process. Thank you.

[MyLIRIKO]

this help me a lot! thanks for the tips 🥰

[ChiburemChukwuma]

Thank you so much for this insightful video

[emmanuelpaul]

Very nice and quick thanks....

Also trying to copy names in multiple cells, but to no avail

[janniemeyer]

Saved this Dummy hours to re invent the wheel. Thank you!

[jinjintogana]

Thank you so much...you made my job easier!

[sonamdhondup]

Thats what I was looking for. Thank you so much

[thepeddler]

I've been doing this for years but yesterday I was working on two different files and copied many of the tabs from one to the other to create a template for my notebooks. Today I came to print my new copied tabs and 1. the column width had changed for bigger and the row height, even though the same as the original, no longer fits my paper, as in ~3/4" longer.
Any ideas what's happening. Oh, there's been an update to my computer too.

[kofiasare]

i would often copy and paste by highlighting the cells which was bothersome. Life saver video thank you