Few Excel Tips
1. CHANGE DIRECTION WHEN YOU PRESS ENTER
Whenever you press enter, you must be thinking why my cell selection shifts down. Why it can’t go UP, Down, Left. Surprised
This is very simple. Do you want to change the direction? So let’s do it
Click on below highlighted button “File”:
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
2. HIDE PAGE BREAKS
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:
3. HIDE SHEET/TABS
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
