How to edit a Selection List ic Calc? 1

[wahnula]

Hello,

I have just started getting familiar with this (OO) suite, Calc showed me an amazing trick that I want to learn to control.

I type proposals all day in Excel2002/XP. To speed things up, I created a list of standard items and placed them below the printed portion of the sheet. This way, I start typing and AutoComplete fills in the rest.

Much to my amazement, when I opened my standard blank Excel proposal in Open Office Calc all those words I placed in the AutoComplete list below the cell became available as a right-click Selection List! No more typing! I just need to get a few other cells to show the Selection Lists I want to see when I right click>Selection List.

There are also a few choices I would like to NOT appear in the list.

What I seek are the keys to the Selection List Kingdom.

Thanks,
Tony

 

[rvnguy]

You really want to use the data > validity tool here to replace your list in the cells.

This will provide you with a dropdown arrow when a cell is highlighted.

Select the range of cells goto tools > validity >select list and a box for the values will appear. Copy & paste your wanted entries.

rvnguy
"I know everything..I just can't remember it all

 

[wahnula]

Ahhh...I seee! Thanks!

Tony

 

[firefytr]

You can also do this in Excel with Data | Validation | List, in a pre-defined list (generally on a worksheet, possibly hidden if desired).

Just fyi.

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a Microsoft MVP? Professional Office Developers Association
- Leonardo da Vinci