M$ Excel Help please

avelanchefan

So I am pretty good with Excel, can do formulas, drop down boxes...blah, blah, blah.

Here is the issue, I want to make a one-to-one copy of a specific spreadsheet. This copy has to be made on a daily basis. The problem is when I do a copy and paste it does not create an exact replica, I have to go back and adjust row heights....etc.

When I tried the "paste special" feature, it created my cells horizontally not vertically.

Google is not coming up with any answers. Can someone please explain specifically on what I need to do.


Thanks

jacob.simpson

right click on your xl sheet name, click on move or copy and tick mark on create a copy, you should be fine.

Ricardo

Are you selecting the whole worksheet using that little empty square right between column A and row 1? That should take all formatting.

pablo_rodz

jacob.simpson wrote: »

right click on your xl sheet name, click on move or copy and click mark on create a copy, you should be fine.

x2 That should work!

If you use the same formatting, but only change the data, you can also create a templet. When saving the document save it as a templet (.xlt)

seeclear

jacob.simpson wrote: »

right click on your xl sheet name, click on move or copy and tick mark on create a copy, you should be fine.

x2! works for me every month and preserves formatting.

avelanchefan

Yep....Jacob that worked perfectly. Really appreciate the help.

Thanks again for all the responses.

jacob.simpson

Great, though i am not very good in xl little tricks we get to learn like this helps in furthering our knowledge. CP rocks