Pasting a document and keeping the formatting

BillVasko

New Member
Joined
Oct 3, 2006
Messages
19
How do I copy a completed document into a new, blank document and keep the formatting of the rows and columns in the original document? Every time I paste, it does not automatically format the new document to look like the original. Thanks!
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

BillVasko

New Member
Joined
Oct 3, 2006
Messages
19
workbook to workbook. i was trying to use this method since i couldn't figure out how to eliminate the extra pages as I mentioned in my other topic. foiled again!
 

BillVasko

New Member
Joined
Oct 3, 2006
Messages
19
well, i've figured out how to eliminate the extra pages, BUT, when I post a document onto my web page, if I created multiple worksheets within the document, none of them will show up on the web. So that is why i need to copy and paste each worksheet into a new workbook, and find a way to keep all of the formatting in the columns and rows.
 

Bill H

New Member
Joined
Mar 23, 2002
Messages
21
How about just copying the entire sheet into the new workbook, data, formulas, formatting, and all.
Right-click on the sheet tab and select "Move or Copy".
In the "To book:" box select the workbook to copy the sheet to.
Check the "Create a copy" check box.
Press Enter.
 

Forum statistics

Threads
1,141,931
Messages
5,709,406
Members
421,635
Latest member
mehdi hannechi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top