Results 1 to 4 of 4
  1. #1

    Member Since
    Mar 31, 2009
    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


  2. #2

    Member Since
    May 20, 2004
    iMac 21" 8GB, MBP 15" 2.5 Penryn, 4 GB/180 GB
    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

  3. #3

    nabl's Avatar
    Member Since
    Dec 13, 2007
    United States of America
    2.1GHz MacBook with 4GB RAM, Mac OS X 10.6, iLife and iWork 09
    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.

  4. #4

    Collin Bl's Avatar
    Member Since
    Apr 07, 2009
    Napier NZ
    27 iMac+Thunderbolt, iMac 20, 2TB dual TC, AppleTV, iPh4S
    Here is a bit of a work round, in case it will do want you want;

    Click for full size

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. iWork/Numbers question
    By Matt Strader in forum macOS - Apps and Games
    Replies: 4
    Last Post: 12-19-2010, 12:02 AM
  2. iWork 09 Numbers - tables question
    By Spook in forum macOS - Apps and Games
    Replies: 2
    Last Post: 05-06-2009, 03:04 PM
  3. Numbers (iWork) Question
    By Mark W in forum Switcher Hangout
    Replies: 1
    Last Post: 10-05-2008, 09:07 AM
  4. iWork 08 - Numbers Question
    By mac57 in forum macOS - Apps and Games
    Replies: 0
    Last Post: 09-30-2008, 10:02 PM
  5. iWork Numbers question?
    By pruppert in forum macOS - Apps and Games
    Replies: 0
    Last Post: 09-03-2007, 03:13 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts