Formula results are shown in worksheet cells, while formulas are visible in the formula bar only so that they won’t appear when you print. Showing formulas in the cells makes it easy to find cells that contain formulas, check for errors, or print with formulas displayed. With a quick key combination you can see formulas instead of formula results in a worksheet. Showing all formulas in all cells To show formulas in all cells press CTRL+` (that little mark is the grave accent mark key). When the formulas are visible, print your worksheet as you normally would. To switch back to showing formula results in all cells, press CTRL+` again.
Tip: If you’re having trouble finding the grave accent mark key (`), it is often located in the upper left corner on keyboards, but not always. If it’s difficult to find on your keyboard, you can also show and hide formulas by going to the Formulas tab and then clicking Show Formulas. To switch back to the standard view, click the button again. Showing the formula of just one cell The process above for all cells isn't available for just one cell or select cells.
Jan 09, 2010 When you reference a cell or cells in a formula you can click on the cell reference in the formula and an arrow appears. If you click on the arrow you have options of relative reference, absolute column, absolute row, or absolute column and row. Also, if you use header columns and rows data references follow these, just look in the formula editor.
It applies to the whole sheet. Some people work around this by typing a single apostrophe before the formula in the cell. For example, '=SUM(1+2+3) Still can't see formulas? Sometimes people have the Formula bar off.
Or, sometimes the sheet is protected from showing formulas. The following steps will help you in these situations. Tip: If you want to expand the Formula Bar to show more of the formula, press CONTROL+SHIFT+U. If the above step doesn't work, make sure the sheet is enabled to show formulas. To do that:. On the Excel menu, click Preferences.
Under Authoring, click View. Under Show in Workbook, select the Formulas check box. This setting applies only to the sheet that you are currently viewing.
If you still can't see the formula for cells, try unprotecting the sheet or the whole workbook. On the Review tab, click Unprotect Sheet or Unprotect Workbook.
Then type the password if necessary.
On 2002-02-26 14:39, Anonymous wrote: Do you guys know if there's a keystroke I can use when I want to lock onto a single cell in a formula, instead of having to type those dollar signs every time? If I want the cells to be divided by the total in L32, could I push something and then click on L32 directly instead of having to type in $L$32 instead? Ro Try typing in =2+l32 and then hit f4 before enter. This acts a little finicky sometimes. If you highlight your whole formula in the formula bar and cycle through f4 you will run through the various absoluting options.
On 2002-02-26 15:08, Anonymous wrote: Perfect, thanks!!!! Couple related questions: 1) If I'm editing a formula that's already on a worksheet, and it refers to four different cells, and I want to go in and change a reference to a single cell to get that locked, is there a way to do so without going in and retyping it with dollar signs? Hit F2 to edit the formula. Highlight the cell of interest and hit f4. 2) Is there a way to reference a cell and instead of locking on the individual cell, lock on only the column or only the row? A1 is relative $a$1 is absolute a$1 is relative column/absolute row $a1 is abosolute column/relative row. Hitting f4 several time will run through these options.
The help file is a great resource for this. See About cell and range references, and click on the note about relative and absolute references. Thanks again, Rohan.
On 2002-02-26 15:08, Anonymous wrote: Perfect, thanks!!!! Couple related questions: 1) If I'm editing a formula that's already on a worksheet, and it refers to four different cells, and I want to go in and change a reference to a single cell to get that locked, is there a way to do so without going in and retyping it with dollar signs? 2) Is there a way to reference a cell and instead of locking on the individual cell, lock on only the column or only the row? Thanks again, Rohan F4 toggles thru all of the combinations of absolute, mixed and relative references.
While editing a formula before pressing F4 highlight the references that you want to change. Sorry, IML didn't see your response. This Message was edited by: Mark W. On 2002-02-26 15:42.