search bar

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Search Bar

Search Bar

resolvedResolved · Low Priority · Version 2010

Jay has attended:
Excel Intermediate course
Excel Advanced course

Search Bar

is there a way to create a search bar could have drop down menus. where you can type in something and i list would come up and you could narrow it down somehow. to search the hole excel sheet

regards

Jay

RE: Search Bar

Hi Jay

Thanks for getting in touch. This is not built in to the Data Validation options in Excel but using various formulas you can create similar functionality. It's described very well here:

http://stackoverflow.com/questions/7989763/excel-2010-how-to-use-autocomplete-in-validation-list

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: Search Bar

thanks


 

Excel tip:

Screen Splitters in Excel

Screen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter.

These icons can be double-clicked to split the screen at the top left of the cell currently in use.

View all Excel hints and tips


Server loaded in 0.07 secs.