exceltoxl.com

Hi there,

Share on Facebook

 

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

10⁺² Keyboard Shortcut Keys

 

Thanks,