Mystery Function!!! 1

[katiekat]

Hi All,

I know I can do something with Excel, I don't remember how, or what it's called, so I can't even search the help files.

Somehow, you can have excel place a scrolling drop down type box at the top of the columns, so you can look through one column all at once, and not have to scroll through the whole spreadsheet.

What is this, and how the heck do I do it?? It would make my life unbelievably easier.

Thanks!
Kate

Holy tek-tips batman!:-0

 

[RoyVidar]

Is it AutoFilter you're looking for? From the Data | Filter menu?

Roy-Vidar

 

[katiekat]

DUH.

THANKS ROY-VIDAR!

That's the one. I don't know why I didn't bother checking that one, and of course, that's what I was looking for.

Thank you so much!


Holy tek-tips batman!:-0

 

[jdegeorge]

I'll give you a star, Roy!

Jim DeGeorge