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
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.