New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

Start a Discussion

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

iWork 09 Numbers Question

Post Reply New Thread Subscribe

Thread Tools

Member Since: Mar 31, 2009
Posts: 3
PinkPotions is on a distinguished road

PinkPotions is offline
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

QUOTE Thanks

Member Since: May 20, 2004
Posts: 243
shades is a jewel in the roughshades is a jewel in the rough
Mac Specs: iMac 21" 8GB, MBP 15" 2.5 Penryn, 4 GB/180 GB

shades is offline
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?

Mellel 3, NWP 2, Scrivener 2.3.1, Tinderbox 5.11.2
LibreOffice 3.6, Accordance 10.0, Adobe CS4, DTP 2.4.3
OS X 10.8.2
QUOTE Thanks

nabl's Avatar
Member Since: Dec 13, 2007
Location: United States of America
Posts: 256
nabl has a spectacular aura about
Mac Specs: 2.1GHz MacBook with 4GB RAM, Mac OS X 10.6, iLife and iWork 09

nabl is offline
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.
QUOTE Thanks
Collin Bl

Collin Bl's Avatar
Member Since: Apr 07, 2009
Location: Napier NZ
Posts: 3,291
Collin Bl is a jewel in the roughCollin Bl is a jewel in the roughCollin Bl is a jewel in the rough
Mac Specs: 27 iMac i5, MBP 13 & iMac 20, 2TB dual TC, AppleTV, iPh4S

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

Click for full size
QUOTE Thanks

Post Reply New Thread Subscribe

« Boot Camp Problems. | Reason 4.0 won't open »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread Starter
Last Post
Numbers (iWork) Question Mark W Switcher Hangout 1 10-05-2008 09:07 AM
iWork 08 - Numbers Question mac57 OS X - Apps and Games 0 09-30-2008 10:02 PM
The QUESTION Game ToddG Schweb's Lounge 159 08-15-2007 05:25 PM
Ask 'me' a question... eric Schweb's Lounge 22 01-12-2007 06:33 AM
iWork pages question.. ingeborg OS X - Apps and Games 1 01-04-2007 05:17 PM

All times are GMT -4. The time now is 05:33 AM.

Powered by vBulletin
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.

Welcome to

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!

(4 digit year)

Already a member?