We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide

Display Formulas in Excel?

Jo4
Jo4 Posts: 6,852 Forumite
Part of the Furniture 1,000 Posts Combo Breaker
in Techie Stuff
How do you display the formulas in Excel? I used to know how to do this but I have forgotten, can anyone please help?

Comments

  • davey4444
    davey4444 Posts: 140 Forumite
    Part of the Furniture Combo Breaker
    CTRL + ` or whatever the key is to the left of 1 on the top line should do it.
  • espresso
    espresso Posts: 16,448 Forumite
    Part of the Furniture 10,000 Posts Combo Breaker
    View, Formula bar.
    :doh: Blue text on this forum usually signifies hyperlinks, so click on them!..:wall:
  • Jo4
    Jo4 Posts: 6,852 Forumite
    Part of the Furniture 1,000 Posts Combo Breaker
    gavin_fran wrote: »
    CTRL + ` or whatever the key is to the left of 1 on the top line should do it.

    That worked a treat, THANKS!
  • Jo4
    Jo4 Posts: 6,852 Forumite
    Part of the Furniture 1,000 Posts Combo Breaker
    espresso wrote: »
    View, Formula bar.

    THANKS for responding. I need to be able to view the formulas in the entire spreadsheet.
  • espresso
    espresso Posts: 16,448 Forumite
    Part of the Furniture 10,000 Posts Combo Breaker
    Jo4 wrote: »
    THANKS for responding. I need to be able to view the formulas in the entire spreadsheet.

    Thanks for asking, as I have learnt something new!

    :beer:
    :doh: Blue text on this forum usually signifies hyperlinks, so click on them!..:wall:
  • Jo4
    Jo4 Posts: 6,852 Forumite
    Part of the Furniture 1,000 Posts Combo Breaker
    espresso wrote: »
    Thanks for asking, as I have learnt something new!

    :beer:

    We all learn something new every day. This is a different way to the way I learnt it but this one is easier to remember. :j
  • fwor
    fwor Posts: 6,942 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    gavin_fran wrote: »
    CTRL + ` or whatever the key is to the left of 1 on the top line should do it.

    Great - I've used Excel for years and never seen that before. Works with OpenOffice spreadsheets as well!
  • isofa
    isofa Posts: 6,091 Forumite
    It's a fantastic shortcut to the deep option in: Tools menu > Options > View tab> Formulas (in the Window Options section)

    :)
  • Jo4
    Jo4 Posts: 6,852 Forumite
    Part of the Furniture 1,000 Posts Combo Breaker
    isofa wrote: »
    It's a fantastic shortcut to the deep option in: Tools menu > Options > View tab> Formulas (in the Window Options section)

    :)

    That is the one I knew!!
  • isofa
    isofa Posts: 6,091 Forumite
    Why it isn't on the View menu I'll never know!
This discussion has been closed.
★ ★ ★ Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 353.5K Banking & Borrowing
  • 254.1K Reduce Debt & Boost Income
  • 455K Spending & Discounts
  • 246.6K Work, Benefits & Business
  • 602.9K Mortgages, Homes & Bills
  • 178.1K Life & Family
  • 260.6K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16K Discuss & Feedback
  • 37.7K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.
Update Your Picture