 |
 |
Idle Banter For non SV and non bike related chat (and the odd bit of humour - but if any post isn't suitable it'll get deleted real quick). There's also a "U" rating so please respect this. Newbies can also say "hello" here too. |
 |
|
|
Thread Tools |
04-09-06, 12:19 PM
|
#1 |
|
Guest
Posts: n/a
|
Excel question
Hi,
Does anyone know how to format a cell so that when clicked on it gives a list where people can only select one of the items in the list. Cheers |
|
|
04-09-06, 12:20 PM
|
#2 |
|
Guest
Posts: n/a
|
I think it's data->validation, then you can say that the contents of the cell can only be that of a set values that you link to. There should be an option for a drop down menu.
|
|
|
|
04-09-06, 12:29 PM
|
#3 |
|
Guest
Posts: n/a
|
Cheers Thor
I've been trying to do that for over an hour now!!! |
|
|
|
04-09-06, 12:35 PM
|
#4 |
|
Guest
Posts: n/a
|
No worries!
|
|
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel | Graciepants | Idle Banter | 15 | 31-03-09 10:52 PM |
| OK Windoze guru's (Excel Question) | timwilky | Idle Banter | 7 | 23-10-07 11:57 AM |
| Another one for the Excel gurus | Jelster | Idle Banter | 6 | 12-06-07 08:48 AM |
| Excel Question | Tris | Idle Banter | 4 | 04-04-07 11:42 AM |
| Quick excel question if some1 can help | Jimmy2Feet | Idle Banter | 4 | 21-11-06 03:27 PM |
