Steps for Inserting Formulas in an Excel Speadsheet

 

  1. Use Print Preview to verify that there is only one page.

  2. Close the Print Preview screen.

  3. Save the Spreadsheet.

  4. Select Tools then Options from the menu bar.

  5. From the Options Dialog box, make sure that the View Tab is the active display.

  6. From the View section of the Options Dialog box, insert a check mark in the Formulas box under Windows Options (See Image below).

    Note: try to remember for future reference. Tools, Options, Formulas

  7. Click OK

  8. Select File, Save As ... from the Menu bar.

  9. Save the file in your directory as Warm-up-formulas.xls

  10. Close the file Warm-up-formulas.xls

  11. Open Warm-up.xls

  12. Select a Cell below the data. (example cell A28)

  13. Select Insert, Object... from the Menu bar.

  14. At the Object dialog box, Select the Create from File tab. (see image)



  15. Select Browse...

  16. Then Select the file Warm-up-formulas.xls, and click Insert.

  17. Then Click OK.

  18. This will insert the formulas in the file Warm-up.xls as an object.

  19. Select Print Preview, and verify that there is only one page.

  20. Close the Print Preview Screen

  21. Print the File.

  22. Do not Save the file Warm-up.xls.
    If you save the file the formulas will be saved in the file. If this happens, simply select the inserted formulas object and delete it.