besides CTRL + ~
2007-07-19 16:27:34 · 4 answers · asked by Rome B 2 in Computers & Internet ➔ Programming & Design
I WANT TO SEE ALL THE FORMULAS ON A SPREADSHEET AT ONCE
2007-07-19 16:36:27 · update #1
I guess to see all formulas at once also means to have their locations and contents handy for manipulations
1. highlight all the cells that contain formula by ctrl-g, special.. button, then choose formulas by clicking radio button next to it and click ok
2. shift-tab or tab/enter will toggle you back and forth among these highlighted cells
3. Stop at the any cell and look up the formula from the formula bar, do the adjustment there if needed and resume browsing by using step 2.
2007-07-19 17:49:13 · answer #1 · answered by AQuestionMark 7 · 0⤊ 0⤋
When you put your mouse over a cell that contains a formula it will appear in the formula line. The formula line has the letters fx at the start. If it is not displayed then you can get it by right clicking on the toolbars which opens up the customize tools dialog box, allowing you to add and subtract buttons.
Under the audit functions you can find buttons that will trace precedents and formulas so you can track the formulas from cell to cell. You can find these buttons in the customization dialog box I mentioned above under the Commands tab, the tools selection at the left and half way down the buttons on the right.
2007-07-19 16:33:43 · answer #2 · answered by Dan S 7 · 0⤊ 0⤋
- Go to Tools menu... Options
- in the View tab, Window Options category, Put a check on Formulas
2007-07-19 17:32:11 · answer #3 · answered by Anonymous · 1⤊ 0⤋
clicking in the results cell and looking in the formula bar?
2007-07-19 16:30:53 · answer #4 · answered by dubbarob 5 · 0⤊ 0⤋