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!
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.
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.