Hello, how do I view formulas in all of the cells for excel 2007? Thanks.
![]() |
Hello, how do I view formulas in all of the cells for excel 2007? Thanks.
It's the same as in Excel 2003, just press
CTRL+` (grave accent, same key as the tilde ~)
This hasn't changed. Under the ribbon is a box that displays the formula of the currently selected cell.
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.
Sorry do not worry, I have figured out how to do it. Thanks again.
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. |