How do I get my status bar back in Excel?

All you have to do now is follow the steps below: From the Tools menu, select Options. Make sure you've got the View tab selected. Make sure the check option for the Status Bar is selected. Click the OK button.

Course Content

Menu in Excel

4m 57s

How to use LearnVern

3m 20s

Quick Access Toolbar

6m 21s

Formula Bar in Excel

2m 5s

Status Bar in MS Excel

5m 23s

Navigation in MS Excel

3m 4s

Shortcuts in MS Excel

4m 15s

Format Painter in MS Excel

2m 29s

Excel Getting Started Quiz

Data Entry in MS Excel

5m 9s

Autofill in MS Excel

5m 42s

Data Entry for Date-Time in MS Excel

5m 46s

Undo-Redo in MS Excel

5m 32s

Comments in MS Excel

4m 1s

Saving File in MS Excel

4m 27s

Excel Data Entry Quiz

Creating Formula in MS Excel

7m 45s

Copy Formula in Excel

3m 35s

Till Date Formula in MS Excel

3m 36s

Pct Calculation in MS Excel

5m 20s

Absolute in MS Excel

6m 10s

Sum Average in MS Excel

6m 5s

Other Common Functions In MS Excel

7m 52s

Excel Creating Formulas Quiz

Formatting Fonts in MS Excel

3m 49s

Adjusting Rows & Columns in MS Excel

4m 2s

Alignment in MS Excel

7m 10s

Formatting Borders in MS Excel

2m 55s

Formatting Numbers in MS Excel

7m 23s

Formatting Date-Time in MS Excel

10m 47s

Conditional Formating in MS Excel

10m 38s

Formatting Tables in MS Excel

8m 43s

Formatting Shapes in MS Excel

7m 5s

Excel Formating Quiz

Resizing Row & Column in MS Excel

7m 18s

Hide-Unhide Row and Column in MS Excel

5m 29s

Copy, Move, Insert Data in MS Excel

5m 37s

Find Replace in MS Excel

6m 35s

Excel Adjusting Layout Quiz

Printing in MS Excel

6m 35s

Page Break Preview in MS Excel

5m 20s

Page Setup in MS Excel

4m 58s

Excel Print Quiz

Creating Charts in MS Excel

7m 13s

Types of Chart in MS Excel

5m 40s

Formatting Charts in MS Excel

6m 36s

Chart Elements in MS Excel

7m 44s

Sparklines in MS Excel

8m 1s

Excel Charts Quiz

Freezing Workbook in MS Excel

7m 28s

Splitting Sheets in MS Excel

6m 39s

Outline in MS Excel

7m 3s

Excel Adjusting Workbook Quiz

Manage Multiple Workbook in MS Excel

6m 48s

Working with Sheets in MS Excel

4m 42s

Copy & Delete Sheets in MS Excel

6m 36s

Use of Formula in Worksheet

9m 22s

Edit Links in MS Excel

10m 43s

Excel Multiple work books Quiz

If Condition in MS Excel

6m 26s

VLOOKUP in MS Excel

6m 2s

VLOOKUP Exact in MS Excel

4m 10s

COUNTIF in MS Excel

4m 25s

Excel If condition VLOOKUP Quiz

Protecting Sheets in MS Excel

4m 55s

Securing Workbook in MS Excel

5m 45s

Password to Workbook in MS Excel

2m 21s

Sharing Workbook in MS Excel

3m 10s

Track Changes in MS Excel

5m 33s

Excel Protecting sheets Quiz

Sorting in MS Excel

6m 38s

Subtotals in MS Excel

7m 26s

Filter in MS Excel

5m 32s

Split Data in MS Excel

4m 21s

Flash Fill in MS Excel

3m 41s

Remove Duplicate in MS Excel

2m 33s

Data Validation in MS Excel

6m 50s

Excel Data Management Quiz

Creating Pivot Table in MS Excel

11m 11s

Manipulating Pivot Table in MS Excel

8m 29s

Adding Slicers in MS Excel

4m 36s

Other Grouping of Pivot Table in MS Excel

4m 40s

Excel Pivot Table Quiz

Macro in MS Excel

7m 29s

Excel Macros Quiz

Excel Assignment Q-1

1m 11s

Excel Assignment Q-2

21s

Excel Assignment Q-3

34s

Excel Assignment Q-4

51s

Excel Assignment Q-5

48s

Excel Assignment Q-6

37s

Excel Assignment Q-7

47s

Excel Assignment Q-8

45s

Excel Assignment Q-9

37s

Excel Assignment Q-10

33s

Master Quiz

50m

Status Bar in MS Excel

MS Excel Course What is MS Excel

Enroll Now For Free

Discussion

Course Content

Menu in Excel

4m 57s

How to use LearnVern

3m 20s

Quick Access Toolbar

6m 21s

Formula Bar in Excel

2m 5s

Status Bar in MS Excel

5m 23s

Navigation in MS Excel

3m 4s

Shortcuts in MS Excel

4m 15s

Format Painter in MS Excel

2m 29s

Data Entry in MS Excel

5m 9s

Autofill in MS Excel

5m 42s

Data Entry for Date-Time in MS Excel

5m 46s

Undo-Redo in MS Excel

5m 32s

Comments in MS Excel

4m 1s

Saving File in MS Excel

4m 27s

Creating Formula in MS Excel

7m 45s

Copy Formula in Excel

3m 35s

Till Date Formula in MS Excel

3m 36s

Pct Calculation in MS Excel

5m 20s

Absolute in MS Excel

6m 10s

Sum Average in MS Excel

6m 5s

Other Common Functions In MS Excel

7m 52s

Formatting Fonts in MS Excel

3m 49s

Adjusting Rows & Columns in MS Excel

4m 2s

Alignment in MS Excel

7m 10s

Formatting Borders in MS Excel

2m 55s

Formatting Numbers in MS Excel

7m 23s

Formatting Date-Time in MS Excel

10m 47s

Conditional Formating in MS Excel

10m 38s

Formatting Tables in MS Excel

8m 43s

Formatting Shapes in MS Excel

7m 5s

Resizing Row & Column in MS Excel

7m 18s

Hide-Unhide Row and Column in MS Excel

5m 29s

Copy, Move, Insert Data in MS Excel

5m 37s

Find Replace in MS Excel

6m 35s

Printing in MS Excel

6m 35s

Page Break Preview in MS Excel

5m 20s

Page Setup in MS Excel

4m 58s

Creating Charts in MS Excel

7m 13s

Types of Chart in MS Excel

5m 40s

Formatting Charts in MS Excel

6m 36s

Chart Elements in MS Excel

7m 44s

Sparklines in MS Excel

8m 1s

Freezing Workbook in MS Excel

7m 28s

Splitting Sheets in MS Excel

6m 39s

Outline in MS Excel

7m 3s

Manage Multiple Workbook in MS Excel

6m 48s

Working with Sheets in MS Excel

4m 42s

Copy & Delete Sheets in MS Excel

6m 36s

Use of Formula in Worksheet

9m 22s

Edit Links in MS Excel

10m 43s

If Condition in MS Excel

6m 26s

VLOOKUP in MS Excel

6m 2s

VLOOKUP Exact in MS Excel

4m 10s

COUNTIF in MS Excel

4m 25s

Protecting Sheets in MS Excel

4m 55s

Securing Workbook in MS Excel

5m 45s

Password to Workbook in MS Excel

2m 21s

Sharing Workbook in MS Excel

3m 10s

Track Changes in MS Excel

5m 33s

Sorting in MS Excel

6m 38s

Subtotals in MS Excel

7m 26s

Filter in MS Excel

5m 32s

Split Data in MS Excel

4m 21s

Flash Fill in MS Excel

3m 41s

Remove Duplicate in MS Excel

2m 33s

Data Validation in MS Excel

6m 50s

Creating Pivot Table in MS Excel

11m 11s

Manipulating Pivot Table in MS Excel

8m 29s

Adding Slicers in MS Excel

4m 36s

Other Grouping of Pivot Table in MS Excel

4m 40s

Macro in MS Excel

7m 29s

Excel Assignment Q-1

1m 11s

Excel Assignment Q-2

21s

Excel Assignment Q-3

34s

Excel Assignment Q-4

51s

Excel Assignment Q-5

48s

Excel Assignment Q-6

37s

Excel Assignment Q-7

47s

Excel Assignment Q-8

45s

Excel Assignment Q-9

37s

Excel Assignment Q-10

33s

Status Bar in MS Excel

How do you change the Status Bar

Now we will see about status bar in MS Excel.

On the downside of our worksheet we can see which is having READY and NUM LOCK option, this bar is known as Status bar.

It is used to show the status of our Excel sheet. If our num lock is ON then it will be shown in status bar.

If we select more than one cell from our sheet, then in status bar we will get average of them, count of how many cells are selected, and sum of selected cells displayed there.

Suppose if we want to know the minimum and maximum values from our selected cells, then we can go to our status bar and right click on it and select minimum and maximum option, which will show the minimum and maximum values from our selected cells.

So without applying any particular formula we can just select the cells and get basic information like average, count of how many cells are selected, minimum, maximum, and sum of all of them.

On the right side of status bar there are three icons, first one is 'Normal' which is displaying our worksheet in normal form, second one is 'Page Layout' which will display the sheet in page format, and the third one is 'Page Break Preview' which is used to see that how much part of the page will get printed.

Just beside those three icons we can see a Zoombar, which is used to zoom our worksheet as per our requirement. Maximum value of zoom which can be done is 400%, and minimum value of zoom which can be done is 0%.

FAQs

The Status Bar is the section at the bottom of Excel where you can see various details about the current mode and any special keys that are active. From the status bar, you can also select multiple worksheet views and zoom in and out on the worksheet.

The Status Bar is the thin strip at the bottom of the Excel window, below the list of worksheets.

The lower edge of the worksheet window is known as the status bar, and it displays various information about an Excel worksheet. It also shows information such as the worksheet's current status, if scroll lock or end mode are enabled, and so on.

All you have to do now is follow the steps below: