Few Simple Excel Tips – Excel Learner Should Know

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”:

Select Options

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:

Select Options:

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

Select Options

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