"Tab" key behavior in Microsoft Excel
Recent, I received a new laptop at work. When I got it, while working on an Excel spread sheet, I got crazy on the keyboard and hit some "magic" key combination that changed the behavior of the "Tab" key.
What happened after the magic combination? The "Tab" key placed the focused cell over a whole page to the right instead of one cell. That is, it would jump to the first cell out of the current cells viewed on my monitor, i.e., it would jump a "whole page" instead of a single cell.
What was the magic combination? No idea.
Time to finally figure it out? Weeks.
The solution? Tools -> Options -> Settings -> Uncheck the Transition Navigation Keys
Apparently, having the Transition Navigation Keys makes the keys typically used in Excel, i.e., Tab, Home, End, arrow, and etc. keys behave as they would in Lotus 123.
Go figure.
What happened after the magic combination? The "Tab" key placed the focused cell over a whole page to the right instead of one cell. That is, it would jump to the first cell out of the current cells viewed on my monitor, i.e., it would jump a "whole page" instead of a single cell.
What was the magic combination? No idea.
Time to finally figure it out? Weeks.
The solution? Tools -> Options -> Settings -> Uncheck the Transition Navigation Keys
Apparently, having the Transition Navigation Keys makes the keys typically used in Excel, i.e., Tab, Home, End, arrow, and etc. keys behave as they would in Lotus 123.
Go figure.
Labels: Annoyances, Humor

2 Comments:
At September 12, 2007 11:09 AM ,
Anonymous said...
You are a genius and you just saved my sanity.
At April 24, 2008 2:55 PM ,
Travis said...
Wow, Google + you = restoration of my sanity. Thanks!
Post a Comment
Links to this post:
Create a Link
<< Home