Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: printing formulas

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    231
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there a way to print an Excel spreadsheet and have it print the FORMULAS in each cell as opposed to the values?

    Thanks for any help offered!

  2. #2
    New Member
    Join Date
    Apr 2002
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ctrl + ~ (tilde right below Esc key) will show you formulas and you can print them.

    On 2002-05-06 08:33, Roni wrote:
    Is there a way to print an Excel spreadsheet and have it print the FORMULAS in each cell as opposed to the values?

    Thanks for any help offered!

  3. #3
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Or you can go to Tools|Options|View tab.

    Under Window options, check the box next to Formulas

    _________________
    ~*Kristy*~

    "Catapultam habeo. Nisi pecuniam omnem mihi dabis, ad caput tuum saxum immane mittam."




    [ This Message was edited by: Von Pookie on 2002-05-06 08:36 ]

  4. #4
    Board Regular
    Join Date
    Apr 2002
    Posts
    231
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    thank you so much. Both suggestions worked, but I absolutely adore the Ctrl ~ way!

    Thanks again!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •