 |
 | 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 / July 2007cycling $ in cell refs
In previous versions of excel one could cycle through the various premutations of A1, $A$1, $A1, A$1, by hitting the F4 key. That functionality appears to have disappeared in excel 2007. Has it moved elsewhere or is there some simple way to get it back? That still works for me. You don't happen to have a new keyboard too, for which you have to enable the function keys with an F Lock key?  SignatureKind regards, Niek Otten Microsoft MVP - Excel | In previous versions of excel one could cycle through the various | premutations of A1, $A$1, $A1, A$1, by hitting the F4 key. That | functionality appears to have disappeared in excel 2007. Has it moved | elsewhere or is there some simple way to get it back? Good guess! I did have a new logitech keyboard and it had the function keys remapped. Turning that off solved the problem. > That still works for me. You don't happen to have a new keyboard too, for which you have to enable the function keys with an F > Lock key? [quoted text clipped - 3 lines] > | functionality appears to have disappeared in excel 2007. Has it moved > | elsewhere or is there some simple way to get it back? |
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.