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!
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,990
Messages
5,545,370
Members
410,679
Latest member
rolandbianco
Top