Below Window will appear and then go to “Advanced” and there you can change the direction of Selection (When you press Enter) as highlighted below:
Click Ok and you are done. Just see below and you will see the magic when I press enter:
Hope you love this one
Sometimes you must have seen page breaks and you might like those. Let’s hide these page breaks then
Page breaks in below image:
Click on below highlighted button “File” to hide this Gridlines:
Below Window will appear and then go to “Advanced” and there you can hide the page breaks as shown below:
It will hide Page breaks. See below image:
Many trainees in my session asks how to hide all Sheet tabs because they want users to navigate through hyperlinks only. So just follow these simple steps:
Click on below highlighted button “File” to hide this Gridlines
Below windows will appear and then go to “Advanced” and there you can hide these sheet tabs:
This will hide Sheet tabs and now you may restrict your user to Navigate through hyperlinks only.
Hope you like this article. Please share your views and comments
How to find duplicates in excel? Hope you read the post “Remove Duplicates in Excel”. Now I am going to explain how you can find these duplicates. There are multiple methods available to Find and…
RANK function performs the Ranking in a range or list of numbers. Function returns the rank position and can assigned as highest or lowest value as 1st Rank
This article has Top Excel Interview Questions and Answers to test your Excel skills. It’s great for beginners who are just starting out, or even pros who want a refresher. The questions cover everything you might need for jobs like data analyst, business analyst, or accountant.
MIN function is used to get the smallest number in range or list of values.MIN function has one required i.e. number1 and optional argument i.e. [number2]
This feature is particularly useful for summarizing data or improving the readability of complex sheets.
Watch: How to use WEEKNUM Function in Excel? What is WEEKNUM Function? The WEEKNUM function in Excel returns the week number of a given date. It is a DATE and TIME function that can be…