• Skip to main content
  • Skip to primary sidebar
  • Skip to secondary sidebar
  • Skip to footer

Computer Notes

Library
    • Computer Fundamental
    • Computer Memory
    • DBMS Tutorial
    • Operating System
    • Computer Networking
    • C Programming
    • C++ Programming
    • Java Programming
    • C# Programming
    • SQL Tutorial
    • Management Tutorial
    • Computer Graphics
    • Compiler Design
    • Style Sheet
    • JavaScript Tutorial
    • Html Tutorial
    • Wordpress Tutorial
    • Python Tutorial
    • PHP Tutorial
    • JSP Tutorial
    • AngularJS Tutorial
    • Data Structures
    • E Commerce Tutorial
    • Visual Basic
    • Structs2 Tutorial
    • Digital Electronics
    • Internet Terms
    • Servlet Tutorial
    • Software Engineering
    • Interviews Questions
    • Basic Terms
    • Troubleshooting
Menu

Header Right

Home » Excel » Status Bar in Excel 2010
Next →
← Prev

Status Bar in Excel 2010

By Dinesh Thakur

The status bar is located at the bottom of the working window of Excel 2010, and at first glance, it may seem that it is mainly a decorative element. However, in Excel, the status bar is an efficient and highly functional interface element, skillful use of which significantly improves productivity and facilitates data processing. In Figure below shows what a standard Excel status bar might look like below.

The icons and controls on the right side of the status bar have already been described earlier (except, perhaps, the icon for switching to the pagination line display mode, but this will be done later). On the left side of the status bar, there is an indicator in which, if the document is ready for work (entering and editing data by the user), the message “Ready” is displayed. It is followed by an icon for switching to the macro recording mode. This element is described in the VBA Programming Part V. By and large, if an empty cell is selected in a working document, this will exhaust the elements, indicators, and icons displayed by default in the status bar. However, you can expand the functionality of the status bar using special settings.

To customize the status bar, right-click on it, as a result of which the Customize status bar list opens.

The list contains many items. By checking or unchecking the checkboxes, you can add or remove indicators and icons in the status bar. For some list items corresponding to the mode indicators, the current state (value) is displayed on the right side. In particular, for a message to appear in the status bar when you switch to the mode of entering uppercase letters, check the box next to the Caps Lock position. In this case, the status bar will look as shown in the figure below.

The aforementioned macro recording icon is displayed in the status line if the Macro recording checkbox is checked. As noted above, the group of view switching icons corresponds to the View mode shortcuts position, and the Scale and Scale slider positions are designed to display the thumbnail and a bar (with a slider) for selecting a scale.

The third section from the bottom in the Status bar settings list is quite interesting. In particular, if you check the boxes next to Average (calculating the Average), Count (number of non-empty cells), Minimum (minimum value), and Sum (Sum of cell values) and then in the working document.

Four additional messages will appear in the status bar if you want to select a range of non-empty cells.

For the selected range of cells, the average value, the number of nonblank cells, the minimum value and the sum of the values ​​in the cells are automatically calculated

More specifically: the Number of nonblank cells is determined in the selected range of cells, and the average value and the total sum of values ​​in nonblank cells are calculated from these cells.

The Number of calculated parameters can be increased by checking the boxes next to the Number of numbers (the Number of non-empty cells with numeric values) and Maximum (maximum of values) positions in the status bar settings list. The result of applying such settings is illustrated in the figure below.

One of the cells contains a text value, so the total Number of nonblank cells is one less than the Number of nonblank cells with numeric values. When calculating the average and sum of values ​​in cells, cells with text values ​​are ignored.

For the selected range of cells, the average value is automatically calculated,

number of nonblank cells, number of nonblank cells with numeric values, minimum number, maximum number, and sum of values ​​in cells.

You’ll also like:

  1. Formula Bar in Excel 2010
  2. Working with Excel 2010
  3. Excel 2010 Components
  4. Zoom IN/OUT in Excel 2010
  5. Name field in Excel 2010
Next →
← Prev
Like/Subscribe us for latest updates     

About Dinesh Thakur
Dinesh ThakurDinesh Thakur holds an B.C.A, MCDBA, MCSD certifications. Dinesh authors the hugely popular Computer Notes blog. Where he writes how-to guides around Computer fundamental , computer software, Computer programming, and web apps.

Dinesh Thakur is a Freelance Writer who helps different clients from all over the globe. Dinesh has written over 500+ blogs, 30+ eBooks, and 10000+ Posts for all types of clients.


For any type of query or something that you think is missing, please feel free to Contact us.


Primary Sidebar

Excel 2010

Excel 2010 Tutorials

  • Excel - Started
  • Excel - Tour
  • Excel - BackStage View
  • Excel - Entering Values
  • Excel - Navigating Workbook
  • Excel - Save Workbook
  • Excel - Open/Close Worksheet
  • Excel - Managing Worksheet
  • Excel - Managing Data
  • Excel - Rows & Columns
  • Excel - Copy & Paste
  • Excel - Find & Replace
  • Excel - Spell Checker
  • Excel - Zoom In/Out
  • Excel - Paginated View
  • Excel - Insert Comments
  • Excel - Insert Text Box
  • Excel - Undo/Redo
  • Excel - Formatting Cells
  • Excel - Formatting Worksheets
  • Excel - Working with Formula
  • Excel - Quick Access Toolbar
  • Excel - Name Field
  • Excel - Formula Bar
  • Excel - Status Bar
  • Excel - Full Screen Mode
  • Excel - Grid and Indexing Fields
  • Excel - Preferences Window
  • Excel - Color Scheme

Ribbon Tab

  • Excel - Ribbon Tabs
  • Excel - Show and Hide Ribbon
  • Excel - Adding Ribbon Groups
  • Excel - Active Label of Ribbon Group
  • Excel - Customizing the Ribbon
  • Excel - Contextual Ribbon Tabs

Other Links

  • Excel - PDF Version

Footer

Basic Course

  • Computer Fundamental
  • Computer Networking
  • Operating System
  • Database System
  • Computer Graphics
  • Management System
  • Software Engineering
  • Digital Electronics
  • Electronic Commerce
  • Compiler Design
  • Troubleshooting

Programming

  • Java Programming
  • Structured Query (SQL)
  • C Programming
  • C++ Programming
  • Visual Basic
  • Data Structures
  • Struts 2
  • Java Servlet
  • C# Programming
  • Basic Terms
  • Interviews

World Wide Web

  • Internet
  • Java Script
  • HTML Language
  • Cascading Style Sheet
  • Java Server Pages
  • Wordpress
  • PHP
  • Python Tutorial
  • AngularJS
  • Troubleshooting

 About Us |  Contact Us |  FAQ

Dinesh Thakur is a Technology Columinist and founder of Computer Notes.

Copyright © 2025. All Rights Reserved.

APPLY FOR ONLINE JOB IN BIGGEST CRYPTO COMPANIES
APPLY NOW