Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Formulas in Excel 07? (https://www.askmehelpdesk.com/showthread.php?t=287984)

  • Dec 3, 2008, 02:58 PM
    Apologisenow
    Formulas in Excel 07?
    Hello, how do I view formulas in all of the cells for excel 2007? Thanks.
  • Dec 3, 2008, 05:18 PM
    JBeaucaire

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

    CTRL+` (grave accent, same key as the tilde ~)
  • Dec 3, 2008, 05:20 PM
    ScottGem

    This hasn't changed. Under the ribbon is a box that displays the formula of the currently selected cell.
  • Dec 8, 2008, 05:51 AM
    Apologisenow
    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.
  • Dec 8, 2008, 05:53 AM
    Apologisenow
    Sorry do not worry, I have figured out how to do it. Thanks again.
  • Dec 8, 2008, 09:21 AM
    JBeaucaire

    I told you the keyboard command for that above. It's the same.

  • All times are GMT -7. The time now is 05:56 AM.