K3bert

It just is

Wednesday, August 22, 2007

"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.

Labels: ,

2 Comments:

Post a Comment

Links to this post:

Create a Link

<< Home