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
Microsoft Excel “DAY, MONTH, YEAR Functions” are date related functions helps to extract the Day, Month or Year from a Date.
Excel Function COUNTIF COUNTIF Excel Function is also one of the most used function in excel. This helps the user to calculate the number of counts based on single logic given by the user. You…
Generate Random Numbers in Excel Using RAND We have got many instances where we needed to generate a random database or values. Rand function is very useful for the users who creates random database for…
File Manager tool is an Excel based tool which helps you to delete or move unwanted files from your system. It requires a source and destination folder (in case you want to move files). First it lists all the files available in the folder or sub-folders then you can select the action to be taken for each file such as Move or Delete. With a click of button, tool will take all necessary actions.
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.
UPPER function is used for changing the text/string to UPPER case in Microsoft Excel. The output of the function returns value in new cell.