Ask Experts Questions for FREE Help !
Ask
    Wonder84lalala's Avatar
    Wonder84lalala Posts: 41, Reputation: 1
    Junior Member
    		  
    #1

    Mar 21, 2007, 06:57 AM
    Display formula in Excel
    Hi,

    Can you please show me how to display all formulas in a spreadsheet? I already calculated the data using formulas in a spreadsheet, now I just want display the formulas. Are there any keyword shortcuts.

    Many thanks.
    colbtech's Avatar
    colbtech Posts: 748, Reputation: 66
    Senior Member
    		  
    #2

    Mar 21, 2007, 07:33 AM
    In Excel 2003: Tools, Options click on the check box that says "Formulas"
    WvR's Avatar
    WvR Posts: 16, Reputation: 3
    New Member
    		  
    #3

    May 18, 2007, 01:40 AM
    In excel press "Ctrl" and ~ do it again to hide formulas
    jord11's Avatar
    jord11 Posts: 1, Reputation: 1
    New Member
    		  
    #4

    Jan 19, 2013, 06:43 AM
    What is the formular to find the average?
    Nubzor16's Avatar
    Nubzor16 Posts: 62, Reputation: 2
    Junior Member
    		  
    #5

    Feb 5, 2013, 09:48 PM
    Like the formual like this?
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

NE 1 know what this formula is for [ 8 Answers ]

E=2= +a+b E is Epsolon symbol B is Beta symbol It was on Treasure map from 1800's LOOK UPPER left corner area

Need a formula: [ 4 Answers ]

(This isn't homework, its part of a puzzle, and its got me stumped) I have 2 known numbers, n and z. They relate thus: n=x*y z=(x-1)*(y-1) n-z=x+y-1 I need to find x and y. Any ideas?

Formula [ 1 Answers ]

IF( and that is a big if) light were to decelerate at the rate of I 13billionth of its original velocity per year , what would be the formula for computing the distance to the most distant observable objects in the universe: FRED

Display text vertically and not horizontally in 1 cell (Excel) [ 2 Answers ]

How would you display a line of text to show vertically after each text in one cell? For example: Total Activity Cost And not Total Activity Cost (in one cell)? Thank you in advance.

Excel Formula needed [ 1 Answers ]

I am keeping an inventory in Excel. Let's say I start with 100 units of widgets, I take 20 widgets from the shelf, but return 10 wdgets later because I didn't use them. I need a formula that shows the 100, then I want to show that I took 20, and then have Excel show that I returned 10. Can...

View more questions Search