Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Illinois
    Posts
    135
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Worksheet-Visible Formulas (2000)

    I am almost sure there's a way to Show Formulas in a worksheet. As usual, knowing you CAN do something is the easiest part with Microsoft. If you don't know the exact way to "ask" Help, you;re Sure Out Of Luck.

  2. #2
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Worksheet-Visible Formulas (2000)

    Tal,
    From the menu Select
    Tools
    Options
    on the View tab Check the box for Formulas
    Chuck Reimer
    I'm from the Government and I'm here to help...

  3. #3
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Worksheet-Visible Formulas (2000)

    If you need to Show Formulas frequently, you can put code like the following into your <!post=personal.xls,118382>personal.xls<!/post> and attach it to an icon on a custom toolbar. <pre>Public Sub Formula()
    With ActiveWindow
    If .DisplayFormulas = True Then
    .DisplayFormulas = False
    Else: .DisplayFormulas = True
    End If
    End With
    End Sub
    </pre>

    The code toggles between Formula View and "Normal" View.

    HTH
    Gre

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Worksheet-Visible Formulas (2000)

    And then there's "Ctrl-~".
    -John ... I float in liquid gardens
    UTC -7DS

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Worksheet-Visible Formulas (2000)

    That adds to the keystrokes a bear <IMG SRC=http://www.collectorsprints.com/images/pooh/pooh-detail-02.jpg>with my size brain can't remember!
    Gre

Posting Permissions

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