iWork 09 Numbers Question

I have columns on my spreadsheet which are drop down boxes which state Yes or No only.

However, I would have preferred if it kept the box blank until I had chosen one. It fills all the boxes with yes and I then need to change to no, but it's confusing to look at.

I would also like it if I could just type Y or N and it would automatically select the right one rather than having to click the box and select. I work faster using my keyboard only it wastes time having to mouse over and click...

Can I do what I am wanting on Numbers???

Thanks in Advance

xxx

Howdy. I don’t have the 09 version of Numbers (only 08, which does not permit this), but in Excel you can add a blank and choose that as the default one. Is there a work around for that? Perhaps use a third entry as a period?

You could do as shades said and add three choices (in order): a space, Yes, and No. However, this would allow a blank to be entered, which you might not like. And there is no way to change the value by typing the first few letters; according to the Numbers '09 User Guide, "when a cell is formatted to use a checkbox or pop-up menu, you can add or change a cell’s content only by using the control."

In your case, though, have you considered just using a Checkbox? It seems more appropriate for the yes/no situation you're describing, and you toggle its state by pressing the spacebar, which is arguably even faster than typing the first letter of a word.

Here is a bit of a work round, in case it will do want you want;


Click for full size