View Full Version : Formulas in Excel 07?
Apologisenow
Dec 3, 2008, 02:58 PM
Hello, how do I view formulas in all of the cells for excel 2007? Thanks.
JBeaucaire
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
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
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
Dec 8, 2008, 05:53 AM
Sorry do not worry, I have figured out how to do it. Thanks again.
JBeaucaire
Dec 8, 2008, 09:21 AM
I told you the keyboard command for that above. It's the same.