xcel2013 How to hide and display the status bar

Source: Internet
Author: User
Tags exit tag name

Excel 2013 hides and displays the status bar tutorial:

Hide and show status bar Step 1: Open EXCEL2010 worksheet, sheet tag name "Computer Statistics", you can see, the bottom status bar does not show up!

Hide and show status bar Step 2: Right button "Computer Statistics tab", pop-up shortcut menu, click "View Code" command item

Hide and show status bar Step 3: Enter VBA mode and press the key combination to display the Immediate window

Hide and show status bar step 4: In the Immediate window, enter: Application.displaystatusbar = True and press ENTER to exit VBA mode.

Hide and show status bar Step 5: Back to the worksheet, you can see the Excel status bar appears!

Hide and show status bar Step 6: The right mouse button status bar, pop-up shortcut menu can be set according to need, to achieve rapid sum of data, average, count, statistics maximum, minimum value, zoom worksheet, view switch and so on operation

Hide and show status bar Step 7: How to hide the display of the status bar for some reason, you can repeat the 1-4 steps above, enter in the Immediate window: Application.displaystatusbar = False and press ENTER to exit VBA mode for implementation.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.