1. Have a look at Data/Validation/List, perhaps that's you are looking for!
2. Pressing Ctrl+: enters current time in the active cell.

Regards,
Stefi

€žBruno€� ezt Ã*rta:

hi there!
I have 2 problems in excel and I count with your help because i don't know
the best way to solve them.

1 - I need to do something like a combobox from where i select one text from
others. How do i do this? Is it possible to do it with lists?

2 - I need a funtion or anything that tells me the precise time hh:mm:ss i
write it and doesn't get updated each time change my file like =now() ? How
do i best do this? (it's to meant to monitor the lenght of phone calls)


Hope you can hel me

Bruno

"Stefi" wrote:

1. Have a look at Data/Validation/List, perhaps that's you are looking for!
2. Pressing Ctrl+: enters current time in the active cell.


1
Where do i check Data/Validation/List ??

2
Ctrl+: solved the problem. Thanks!!!!
Although can you tell me if it works in OpenOffice?

1. Data menu/Validation submenu/Choose List from the drop down list.
2. As far as I know No, but perhaps you can use the NOW() function, because
it is not updated automatically in OpenOffice.

Regards,
Stefi

€žBruno€� ezt Ã*rta:

"Stefi" wrote:

1. Have a look at Data/Validation/List, perhaps that's you are looking for!
2. Pressing Ctrl+: enters current time in the active cell.


1
Where do i check Data/Validation/List ??

2
Ctrl+: solved the problem. Thanks!!!!
Although can you tell me if it works in OpenOffice?