Question Locked

HOW DO I ADD A DROP DOWN MENUE TO A EXCELL SPREAD SHEET WITH HIDDEN NOTES I

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
HOW DO I ADD A DROP DOWN MENUE TO A EXCEL SPREAD SHEET TO COLLECT CLIENT INFO AND DATA, WITH HIDDEN NOTES IN THE FIELD NAMES BUT WHEN I CLICK IN THE FIELD NAME BOX I CAN ALSO CLICK THE NOTES THAT ARE ATTACHED IN THE FIELD, IM PULLING OUT MY HAIR IN JA

5 replies

by .martin.

doesn't make any difference, just letting you know...

by purpleskys

http://spreadsheets.about.com/od/excelformatting/qt/070814unhiderow.htm
http://office.microsoft.com/en-us/excel-help/create-or-remove-a-drop-down-list-HP005202215.aspx

Tutorials are a wonderful thing...on a note from your other post, excel is a spreadsheet not a database, you should look at access if you're wanting to create a database.

edit to add: and please, stop yelling at us, we hear you the first time as Martin has said.

by sundarmurthy

You have not mentioned what version of office you are using, although you would have to go to data menu -> filters->select autofilter , before that place the cussor position at the top the cell from where you want to hide the date . Now you will get a menu from which you can select the pirtuclar name or no etc.The remaning data will be hidden , and you can sort the data ascending or descending order.Display all option will display all the hidden data.

This discussion is closed to new replies.