How do I display the number of records of a search in the status bar

[kirstie]

Hello,

I amended an excel document at work but now the status bar has stopped displaying the number of records in the status bar from a filtered search. It used to show for example, "35 of 491 records".

I only inserted three columns and put formulas in them. I have no idea how I have stopped this status bar display!!

Please could anyone help me to put it right?

ps - I really hope I don't have to put a MACRO in as I have no idea how to do this; or how I could have removed that in the first place. I have tried reading other posts and they mention VBA and I have no experience in this or what they are trying to say!

Thank you

 

[jeffreybrown]

Kristie,

Might this help?

http://support.microsoft.com/kb/213886

 

[kirstie]

What a simple solution!! Trust me to be overcomplicating it. Thanks Jeff.