How do I copy spreadsheet data as shown to another spreadsheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I copy data from one Excel spreadsheet to another without losing the
formulas, number formats, colors and column/row widths and heights?
 
<Ctrl><C> and <Ctrl><V> will take it across as is, except for row heights and
column widths. After <Ctrl><V>, right click in the selection, click on Paste
Special, and click column widths to set column widths.
 
U¿ytkownik "trainer07 said:
How can I copy data from one Excel spreadsheet to another without losing the
formulas, number formats, colors and column/row widths and heights?
Click to expand...

right click on sheet tag and choose copy to another file./ new file
mcg
 
You must log in or register to reply here.

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How do you copy and past data from one spreadsheet to another? 1
Lookups - how to obtain data from a master spreadsheet into another 5
Appending Data from one spreadsheet to another 4
merging spreadsheet data 1
Copy or Move a spreadsheet 1
Copying from one spreadsheet to another - formulas don't come alon 2
merging spreadsheets 2

Back
Top