How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, Bachelor of Science - Engineering Consultant
Category: Programming
Satisfied Customers: 9666
Experience:  Vast experience in Excel programming and business solutions
53785
Type Your Programming Question Here...
John D is online now
A new question is answered every 9 seconds

How do I save formulas only in Excel

Resolved Question:

How do I save formulas only in Excel?
Submitted: 7 years ago.
Category: Programming
Expert:  John D replied 7 years ago.

Hi,

 

The way to save formulas only, is to delete the cells that have fixed values keeping only the cells that have formulas, then choose the Formula display option, i.e.

 

Excel 2003, 2000, XP, 97

click Tools > Options > View tab > Formulas.

 

Excel 2007

click Office button > Excel Options > Advanced > Display options for this worksheet...> Show formulas in cells instead of their calculated results

 

If you have a large sheet with values and formulas I can do it for your using vba code if you like. Let me know if that is what you want so that I can send you the instructions for posting the file.

 

Hope this helps.

 

 

 

John D and other Programming Specialists are ready to help you