Excel status bar -count not showing

Copper Contributor

I use pivot table excel spreadsheets - I do not make the pivot tables, so only have a rudimentary understanding of them.

 

My issue should be easily solved, but it is not.

Win 7 professional work envirnment 

Exel 2016

count and numerical count are checkmarked

 

On the bottom status bar, next to ready, if I unselect an item in a Filtered row, I see the status of items change, say from 10450 to 10320 - most of the time 

 

What I want is for it to STAY all the time say 10450 - I unselect 3 items and it goes to 9840 

However, I want it to show me the original numbers, so when I am presenting to a group I can say it starts from 10450 and taking these off, we now have...  

2 Replies
Hi Ed, could you post a screen shot of what you are looking to do?

I'm not quite understanding what you are needing.

Ed, Wyn,

 

I guess we speak about Excel status bar at very bottom of the workbook. For my knowledge its not possible to customize it, you may use it only as is.

 

All counts here are working on selected cells only, you may see if hover by mouse one of the indicators (e.g. Count) 

 

StatusBar.JPG