« Important Days to Remember in September | Excel Data Tables Are Awesome..! » |
Tampering Our Own Excel Workbook
excel_usage, Learn ExcelHi there,
I think you might get little confused (about this post) seeing the Title. Worry not; this post is regarding how to hide the workbook features like:
- how to hide Developer Tab
- how to hide Worksheet Tabs
- how to hide Row and Column headers
- how to hide Formula Bar
- how to hide Horizontal Scroll Bar
- how to hide Vertical Scroll Bar
Let's see how each feature tamper our workbook
...
HOW TO HIDE DEVELOPER TAB:
Goto Windows Button --> Excel Options --> Popular
--> Top Options for Working with Excel -->
Uncheck Show Developer Tab in the Ribbon
BEFORE
AFTER
HOW TO HIDE WORKSHEET TABS:
Goto Windows Button --> Excel Options --> Advanced
--> Display Options --> Uncheck "Show Sheet Tabs"
BEFORE
AFTER
HOW TO HIDE ROW and COLUMN HEADERS:
Windows Button --> Excel Options --> Advanced -->
Display Options for this worksheet -->
Uncheck "Show Row and Column Headers"
This can also be done using VIEW TAB --> uncheck "Headings" in the Show/Hide group.
BEFORE
AFTER
HOW TO HIDE FORMULA BAR:
Goto VIEW TAB --> Show/Hide Group
--> Uncheck FORMULA BAR
This can also be done using VIEW TAB --> uncheck "Formula BAR" in the Show/Hide group.
BEFORE
AFTER
HOW TO HIDE HORIZONTAL SCROLL BAR:
Windows Button --> Excel Options --> Advanced -->
Display Options for this workbook -->
Uncheck "Show Horizontal Scroll Bar"
BEFORE
AFTER
HOW TO HIDE VERTICAL SCROLL BAR:
Windows Button --> Excel Options --> Advanced -->
Display Options for this workbook -->
Uncheck "Show Vertical Scroll Bar"
BEFORE AFTER
HAVE YOU TAMPERED YOUR WORKBOOK?
Have you ever tried tampering your workbook. Please do share your ideas, suggestions and experiences in your work life about this topic in the below comments section. Use this opportunity to express your views on this space.
If you like this post, please do share this post on your social networking sites to help your co-hearts to learn, share and XL their Excel knowledge. Be the first of your friends.
If you want to support me please do register here for free to receive latest updates from the blog.
SOME IMPORTANT LINKS:
What is the Difference Between a Formula & a Function
How to create Customized Tab Using Excel 2010
Thanks,
You must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments