Business Analytics
Data Analyst
Programming for Data Science
Predictive Analytics for Business
Are you a data enthusiast? Join us for a ride on your data and automate your stuffs

Few Simple Excel Tips – Excel Learner Should Know

Basic Excel Tricks Logo New
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”:

Excel Tricks

Select Options

Excel Tricks

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:

Excel Tricks

Click Ok and you are done. Just see below and you will see the magic when I press enter:

Excel Tricks

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:

Excel Tricks

Click on below highlighted button “File” to hide this Gridlines:

Excel Tricks

Select Options:

Excel Tricks

Below Window will appear and then go to “Advanced” and there you can hide the page breaks as shown below:

Excel Tricks

It will hide Page breaks. See below image:

Excel Tricks

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:

Excel Tricks

Click on below highlighted button “File” to hide this Gridlines

Excel Tricks

Select Options

Excel Tricks

Below windows will appear and then go to “Advanced” and there you can hide these sheet tabs:

Excel Tricks

This will hide Sheet tabs and now you may restrict your user to Navigate through hyperlinks only.

Excel Tricks

Hope you like this article. Please share your views and comments

Author:
Excelsirji.com was started with the thought of making people experience easy while working with Excel, data analytics, vba, automations etc.

Leave a Reply

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