 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2006How to restore F2 functions
Lately, I am unable to outline, when entering edit mode in a cell, the cell's formula-related cells. I used to, upon pressing F2, see a cell's formula and, highlighted in differing colors, the cells referenced by the formula to be edited/viewed. Any ideas how this very useful feature may be restored? You can see the highlighted cell refs either in the formula bar or in the cell depending upon the settings at Tools>Options>Edit>Edit Directly in Cell. Gord Dibben MS Excel MVP >Lately, I am unable to outline, when entering edit mode in a cell, the >cell's formula-related cells. I used to, upon pressing F2, see a cell's >formula and, highlighted in differing colors, the cells referenced by >the formula to be edited/viewed. > >Any ideas how this very useful feature may be restored? I USED to be able to see the highlighted cells and the formula, but with or without Edit Directly in Cell enabled, and the formula displayed in the cell, referenced cells are no longer highlighted... Any ideas how to restore the cell highlighting? >You can see the highlighted cell refs either in the formula bar or in the cell > [quoted text clipped - 8 lines] >> >>Any ideas how this very useful feature may be restored?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.