4

I tested some kinds of copying - but i copy just values instead formulas. Is there any way to copy Excel formula from multiple cells and paste it into a text document?

Improve this question

2 Answers 2

Reset to default
8

If you go to Formulas card, inside Formulas Auditing section there is a button Show Formulas.

enter image description here

Once you enabled it (clicked on it) you'll be able to copy formula from Excel to Notepad ++.

Improve this answer
1
  • This does not work in Excel Online :(
    – Peter Lillevold
    Commented May 17, 2023 at 14:45
1
  • In Excel, choose Options from the Tools menu. Excel displays the Options dialog box. Make sure the View tab is selected.
  • Ensure that the Formulas check box is selected.
  • Click on OK. Excel should now be displaying formulas.
  • Select the cells whose formulas you want to copy to Notepad.
  • Press Ctrl+C to copy the cells to the Clipboard.
Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.