Results 1 to 2 of 2
  1. #1

    Member Since
    Apr 23, 2011
    Excel pros and cons template
    I am running Excel For Mac 2011. When creating a "pros and cons" template spreadsheet, there is a drop down list called "How important is each item, on a scale of 1-5?" How can I change this to a scale of 1-10? I want to change both the text and the number of items in the drop down list.

  2. #2

    McBie's Avatar
    Member Since
    Apr 26, 2008
    iPad Pro 12.9 latest iOS
    Click on the cell where you can choose 1 - 5 ( Importance )
    From the top menu, select Data.
    From the Data menu, select Validation
    A small window will appear and there is a field called Source.
    Type the values that you want to see in the drop down box, separated by a semicolon.

    If you want to speed things up, select all cells you want to do this for and then do Data / Validation etc.... as described above.

    Cheers ... McBie
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila.
    The bitterness of poor quality remains long after the sweetness of low price is forgotten.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Apple TV Pros and Cons
    By Rocky1951 in forum Apple TV
    Replies: 22
    Last Post: 11-07-2017, 04:00 AM
  2. Macs vs PC pros cons
    By jmart193 in forum Schweb's Lounge
    Replies: 4
    Last Post: 08-26-2011, 07:25 AM
  3. pros and cons macs v pc
    By jaylox in forum Apple Notebooks
    Replies: 24
    Last Post: 04-12-2011, 07:05 PM
  4. FileVault - pros? cons?
    By MotorcycleBetty in forum macOS - Operating System
    Replies: 1
    Last Post: 02-05-2009, 11:51 PM
  5. Parallel pros and cons?
    By euro_chic in forum macOS - Apps and Games
    Replies: 4
    Last Post: 06-16-2008, 04:19 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