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.

Excel pros and cons template

Post Reply New Thread Subscribe

Thread Tools

Member Since: Apr 23, 2011
Posts: 57
matty1 is on a distinguished road

matty1 is offline
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.
QUOTE Thanks

McBie's Avatar
Member Since: Apr 26, 2008
Location: Belgium
Posts: 2,667
McBie is a splendid one to beholdMcBie is a splendid one to beholdMcBie is a splendid one to beholdMcBie is a splendid one to beholdMcBie is a splendid one to beholdMcBie is a splendid one to beholdMcBie is a splendid one to beholdMcBie is a splendid one to behold
Mac Specs: 2013 MBA 13" - OS X 10.10.4

McBie is offline
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.
QUOTE Thanks

Post Reply New Thread Subscribe

« Billed by iTunes for AirDrop Transfer | Sharing in imovie 10 »
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
Macs vs PC pros cons jmart193 Schweb's Lounge 4 08-26-2011 07:25 AM
Pros and Cons of upgrading 27" iMac (2010) to SSD HD bentharbour Apple Desktops 5 04-16-2011 04:01 PM
Questions about accessories for Notebooks Macswitcha Other Hardware and Peripherals 25 02-10-2009 01:10 PM
inital thoughts on Pros and Cons of Apple TV Other Hardware and Peripherals 13 04-23-2007 01:00 AM
PB 15" pros & cons jdscott Apple Notebooks 7 04-06-2004 06:44 PM

All times are GMT -4. The time now is 10:03 PM.

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?