Moving formulas over to new column after copying Microsoft Excel spreadsheet

1146500 pts.
Tags:
Microsoft Excel
Hi, Here's what I want to do. I would like to copy an Excel worksheet to a new sheet but there's the catch: I need to move all of the formulas into a new column. I just want to move them over one column. How can I arrange this? Or would I just have to do this manually?
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    There are several ways to do it. Either you can use Find & Replace option to do the job or can use relative cell reference to do the same. Here is a link from Microsoft: https://support.office.com/en-us/article/move-or-copy-a-formula-1f5cf825-9b07-41b1-8719-bf88b07450c6

    140,480 pointsBadges:
    report
  • azohawk

    I'm a little confused on what you are doing but from what I am understanding you want what was in column A in the old worksheet to be column B in the new worksheet. If that is the case, when you paste in the new worksheet, but past in column B.

    Or, after you paste, highlight the column A (or the cells in column A) right click-->insert-->move right.

    4,055 pointsBadges:
    report
  • ToddN2000
    Are you looking to get a list of all the formulas in one sheet moved to another sheet in a single column as a list?
    133,790 pointsBadges:
    report
  • ToddN2000
    If you are looking for a list, check out this link. It has the VBA code and step to do it: https://www.extendoffice.com/documents/excel/2220-excel-list-all-formulas.html
133,790 pointsBadges:
report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: