Thread: Excel pros and cons template
11-04-2013, 01:05 AM #1
Excel pros and cons template
- Member Since
- Apr 23, 2011
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.
11-04-2013, 06:37 AM #2
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 ... McBieA 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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Rocky1951 in forum Apple TVReplies: 15Last Post: 10-20-2015, 02:04 AM
By jmart193 in forum Schweb's LoungeReplies: 4Last Post: 08-26-2011, 07:25 AM
By jaylox in forum Apple NotebooksReplies: 24Last Post: 04-12-2011, 07:05 PM
By MotorcycleBetty in forum OS X - Operating SystemReplies: 1Last Post: 02-05-2009, 11:51 PM
By euro_chic in forum OS X - Apps and GamesReplies: 4Last Post: 06-16-2008, 04:19 PM