Essentially the [Tab] key is used for navigate between cell. You can use the [Tab] key, even if the [Scroll Lock] or sheet protection is enabled. If the key does not however help you navigate, you can configure it to do so. Just try carry out the following steps:
> Open Excel
> Go to 'File' tab
> Then go to Excel 'Options'
> Click the 'Advanced' option on the left panel.
> Go to the 'Lotus Compatibility' section
> Clear the 'Transition Navigation Keys' option.
> Click 'OK' to continue.
> Done enjoy
No comments:
Post a Comment