Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
F- Keys
Morning group,
There use to be an F-Key that when you placed your cursor on the cell that had a formula in it, that it would tell you what that cell calculated too. I'm using Excel version 2002. Or did that go by the wayside with the newer versions coming out. Thanks for all your help. Sulley |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
F- Keys
Maybe you mean this?.....
Select a cell containing a formula Press [F2].....the cell is now in edit mode Press [F9].....to see the calculated result. Press [ESC] to reset the cell back to the formula DON'T press [enter]...unless you want the value to replace the formula Note: if you select only part of a formula and press [F9], you'll see the calc'd value for what you selected. Does that help? *********** Regards, Ron XL2002, WinXP "Sulley" wrote: Morning group, There use to be an F-Key that when you placed your cursor on the cell that had a formula in it, that it would tell you what that cell calculated too. I'm using Excel version 2002. Or did that go by the wayside with the newer versions coming out. Thanks for all your help. Sulley |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
F- Keys
Thanks allot Ron, that was what I was looking for, and thank you for the
rapid reply. Sulley "Ron Coderre" wrote in message ... Maybe you mean this?..... Select a cell containing a formula Press [F2].....the cell is now in edit mode Press [F9].....to see the calculated result. Press [ESC] to reset the cell back to the formula DON'T press [enter]...unless you want the value to replace the formula Note: if you select only part of a formula and press [F9], you'll see the calc'd value for what you selected. Does that help? *********** Regards, Ron XL2002, WinXP "Sulley" wrote: Morning group, There use to be an F-Key that when you placed your cursor on the cell that had a formula in it, that it would tell you what that cell calculated too. I'm using Excel version 2002. Or did that go by the wayside with the newer versions coming out. Thanks for all your help. Sulley |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ARrow Keys | Excel Worksheet Functions | |||
Disable CUT via toolbars or shortcut keys | Excel Discussion (Misc queries) | |||
my arrow keys don't work. | Excel Discussion (Misc queries) | |||
How to fix keys t s h c v non-responsive only in Excel? | Excel Discussion (Misc queries) | |||
Cursor Keys does not change cell focus | Excel Discussion (Misc queries) |