Ask Experts Questions for FREE Help !
Ask
    Apologisenow's Avatar
    Apologisenow Posts: 295, Reputation: 2
    Full Member
    		  
    #1

    Dec 3, 2008, 02:58 PM
    Formulas in Excel 07?
    Hello, how do I view formulas in all of the cells for excel 2007? Thanks.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Dec 3, 2008, 05:18 PM

    It's the same as in Excel 2003, just press

    CTRL+` (grave accent, same key as the tilde ~)
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #3

    Dec 3, 2008, 05:20 PM

    This hasn't changed. Under the ribbon is a box that displays the formula of the currently selected cell.
    Apologisenow's Avatar
    Apologisenow Posts: 295, Reputation: 2
    Full Member
    		  
    #4

    Dec 8, 2008, 05:51 AM
    In excel 2003 there was the function of being able to go to tools then options and you were then able to tick the box for show formulas for all of the cells. This would then show the formula inside the cell for all of that worksheet. How do I do this in excel 2007? Thanks.
    Apologisenow's Avatar
    Apologisenow Posts: 295, Reputation: 2
    Full Member
    		  
    #5

    Dec 8, 2008, 05:53 AM
    Sorry do not worry, I have figured out how to do it. Thanks again.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #6

    Dec 8, 2008, 09:21 AM

    I told you the keyboard command for that above. It's the same.
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!

Excel 2007 to have excel 2003 look? [ 6 Answers ]

Hey I have Microsoft Excel 2007, from my course at college I have been given instructions to do a task. However these instructions are for excel 2003. How do I change my excel 07 to look like excel 03 so that it is easier. I know there is a way, help greatly appreicated thanks.

Excel formulas [ 5 Answers ]

Hello I want to do something like the formulas SUMIF but with a text. For example two cell must be equal A b c Parts number Description qty 12545 bearing XKL 10 units

Calc. Empirical formulas and molecular formulas [ 1 Answers ]

:eek! : a sample is made of 18g of C and 81.5g of H... the molecular mass of the compound is 104g/mole calc. the empirical formula... calc. the molecular formula OK.. so I got the moles, I think.:confused: . C= 18g X 1mole = 1.4987g 1 ...

View more questions Search