Pasting a document and keeping the formatting

B

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

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Sort by date Sort by votes
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!
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question
Excel Membership Data to Word Document
Replies
7
Views
228
Beaglebud
B
O
  • Solved
VBA Novice here: Opening a new Word Document from Excel
Replies
2
Views
228
Offroadracer_814
O
P
  • Question
Word create or open with VBA functionality?
Replies
1
Views
185
SamDsouza
S
R
  • Question
Print Batching
Replies
7
Views
322
John_w
J
E
  • Question
Old Question Still Unanswered - Document Inspector
Replies
1
Views
180
Kerryx
K

Forum statistics

Threads
1,214,641
Messages
6,120,691
Members
448,978
Latest member
rrauni

Share this page

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
Back
Top