Excel tab key issue


Today I come across a new problem in excel. When I press tab button in excel, it jumps to last column instead the second column.

Solution:

This problem is due to “transition navigation key” option is enabled in Excel. To uncheck this option

Excel 2010 – 2007.

  1. Go to file and select options.
  2. Select advanced option, below you will see a menu called Lotus compatibitlity.
  3. Uncheck the box “Transition navigation keys” and press ok.

EXCEL 2003:
• From the Menu bar choose TOOLS > OPTIONS
• Select the TRANSITION tab
• Under SETTINGS clear/uncheck TRANSITION NAVIGATION KEYS check box
• Click OK to save the change

The problem solved.

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: