Monday, October 17, 2016

Show Hide Scroll Bars to Make Professional Looking Excel Tools

Show hide scroll bars excel is allow you to build more professional looking excel tools without scrolling. Therefore, if you know how to show hide scroll bars in excel it is a bonus for you. Further it is a simple setting in excel and most  of users don't know about it. Now let's see how we can use this cool feature.

Show Hide Scroll Bars in Excel

  • Click on the File
  • Then Click on the Options
  • After that Select the Advance on the left side selections
  • Finally scroll down to Display options for this workbook


Now you can see there are two tick boxes named Show horizontal scroll bar & Show vertical scroll bar as above picture. They are ticked by default and remove the tick to hide scroll bars. If you change you your mind you can tick them again to show the scroll bars.
There is a small video to demonstrate this and also how to enable disable sheet navigation. You can check it here.


Featured Post

XLOOKUP in Excel: The Ultimate Guide to Dynamic Data Lookup

Excel is a powerful tool for analyzing data, but sometimes finding specific data points can be a headache-inducing task. That's where XL...