How do you copy and past data from one spreadsheet to another?

G

Guest

How can I copy data from one spreadsheet to another while keeping the
formats, column widths and row heights in tact? When I do a copy and paste,
the data doesn't look the same when it's pasted.
 
G

Guest

Right click the tab of the worksheet you want to copy...highlight move or
copy sheet, a dialog box will open, click the copy box and there will be a
drop down for a new work book or any others that are open, choose the one you
want and the location you want the sheet to go to.

That should do it!

Have a good day.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I copy spreadsheet data as shown to another spreadsheet? 2
copy/paste row with one formula 6
Copy row heights 1
Copying and pasting table info and cell formating in one hit 3
Copying excel worksheets to new worksheet 2
Copy/Past from Word-spreadsheet format alignment disregarded 3
how do I link to another sheet in workbook? 12
Appending Data from one spreadsheet to another 4

Top