Status Bar not showing

New Contributor

Office 365 - status bar does not show. I right click and get the options under "Customize Status Bar" pop-up. I don't have anything in Options -> Advance -> Display - no show status bar. I check and uncheck everything on the Customize Status Bar pop up. There's no count, no sum, nothing showing at bottom. Yes I have checked it all off. I have selected and unselected sum, count, etc. I've tried unchecking and checking it all.

I've tried to macro suggestion - didn't work. I've tried the formatting as number option. Blank workbook. Reinstalled. Patched. 


If I enter in random letters and numbers it then shows up (count). So I can not select empty cells to count? There has to be data in it? I want to count empty cells!

3 Replies


All those options are only displayed if you have selected multiple cells of which at least two are not empty.

@Hans Vogelaar - it only counts cells that have something in them. It will not count empty cells at all even if I select 1 empty and 4 or more cells with text/numbers. I will only get a count of the cells with an entry. I need to create coloured patterns in excel, they don't have text in them. I need to count cells that have a fill colour. Instead now I have to select every cell in the sheet, put a 0 in it, and make the text white. I wish I could just select empty cells and have them count at the bottom.

best response confirmed by Aquilo199 (New Contributor)


I'm sorry for you, but the status bar simply doesn't work that way. It counts only filled cells, not selected cells.