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

Download Practice File

You can also practice this through our practice files. Click on the below link to download the practice file.

Recommended Articles

Excel VBA Course : Beginners to Advanced

We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion

This course is going to help you to excel your skills in Excel VBA with our real time case studies.

Lets get connected and start learning now. Click here to Enroll.

Secrets of Excel Data Visualization: Beginners to Advanced Course

Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.

This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.

So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *