Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


EXCEL copy formulas

EXCEL copy formulas

EXCEL copy formulas

What did EXCEL do to copying formulas from one spreadsheet to another???

How does one get around this change?

Am I missing something very obvious?


RE: EXCEL copy formulas

Try going to the cell, highlight the formula, copy & then paste to the other spreadsheet.

RE: EXCEL copy formulas

Highlight and copy the formula in spreadsheet #1. Then in spreadsheet #2 RIGHT CLICK where you want to past.

There are a range of Paste options available. You have to hover over the icons to see what they do, but you can paste the values only, formulas only, links only, paste with formatting included or not included. If you hit the "Paste Special" button, then I think you paste combinations of the just mentioned options.

RE: EXCEL copy formulas

...and keep in mind that the row or column of the cell that you paste the formula text into may very well need to be the SAME ROW & COLUMN as the cell that you copied the formula from.


glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: EXCEL copy formulas

I'm sorry I wasn't more clear. I'm trying to copy an entire worksheet or part thereof and paste it into a 2nd workbook as a new work sheet. I have done it in the past. But EXCEL was NOT being cooperative. I ended up asking the secretary to do it and she got it to work on the first try. I wasn't watching her so I don't know what swear words she used to make the computer cooperate.

Thanks for the assistance.


RE: EXCEL copy formulas

Jim - I'm still not clear what your problem was. If you tell us in what way Excel was not cooperative, we might be able to come up with a solution that doesn't involve bothering your secretary.

Doug Jenkins
Interactive Design Services

RE: EXCEL copy formulas

You right-click the tab of the sheet and select "Move or Copy...," which allows you to move or copy the entire sheet to the same workbook or any other open workbook. It's been like that for at least decade.

TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm

RE: EXCEL copy formulas

I have developed a spreadsheet/workbook )i.e. multiple tabs) that has many of my spreadsheets in separate tabs/pages/sheets. I wanted to copy one of the sheets or some part of it to another workbook with some different sheets/tabs/pages. I was not careful in how I started the second workbook and I assume I had a separate instance of EXCEL. When I copied the part of the sheet I wanted EXCEL wouldn't let me paste it in the second workbook. I do this all the time in Lotus but EXCEL was being cranky. I know, I know they won't work exactly alike. I didn't know the right click on the tab (Thank you IRstuff) to copy the worksheet. I couldn't find the move command at all, except in the help file which seemed to assume it was readily available. It was one of these frustrating moments when you think you something should work but it won't. Before I started smashing the mouse I talked the secretary into trying to do it. She got it to work on her first try or so she claims. Anyway I have a lot of new thinks to try and see if they work now.

Thanks to all who made suggestions.


RE: EXCEL copy formulas

She probably had both open in the same instance of excel. Copy within an instance works very differently than copy between instances.

RE: EXCEL copy formulas

Yes, I think davidbeach is right. I had many problems with copying data between excel 2010 windows when spreadsheets were opened in separate instances. I always opened the files in separate instances so I could have one workbook open on each of my monitors. However when attempting to copy between the instances, the formulas wouldn't copy over. Things seem to be working much better after switching to Excel 2013 and now 2016.

Read over the following two links. They should help clear things up.


RE: EXCEL copy formulas

One way would be to save as the master spreadsheet with another name then revise the input data. If the input is on a separate tab then copying & pasting of the entire tab is as follows: Click on the top left of the spreadsheet tab to highlight the entire page. Select copy and paste on the top left corner of the page to be revised. Note cell locations of formula or data on both should exactly be the same.

RE: EXCEL copy formulas

Note the top left corner cell is at the left of the column letter row and above the row number column.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close