Copying from one spreadsheet to another - formulas don't come alon

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

Guest

In Office 2000.

I have a spreadsheet, and I open another instance of Excel. In the first
spreadsheet I select some rows and columns and copy them. I then paste them
in the second spreadsheet.

The values copy, but the format and formulas do not.

Paste -> Special gives me options to paste in the range of cells as an image.

So how do I copy the formulas from one spreadsheet to another?
 
this may not be the most elegant way but you could copy the formula from the
formula bar at the top of the screen except for the leading = sign. Then
paste into the new workbook and then add the = back into the 2nd workbook.
 
Dan,

There are some known issues with copying and pasting to a different
instance of excel. For example, copy:visible cells then paste in a new
instance will paste all cells not just the visible ones that were copied.

Is there a reason you must use a different instance of excel rather than
just opening a new workbook?
 
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

Copying Formulas 2
Use Macro to Copy and paste formulas from one spreadsheet to anoth 3
Paste Special Values 2
pasting content copied from nonadajacent cells 1
I can't copy and paste equations 0
copying a formula 1
Excel formula to copy/paste formula needed please. 4
Auto Fill Format or Copying Formulas 1

Back
Top