Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 19th 05, 04:55 PM
Webgirl
 
Posts: n/a
Default How do you change a drop-down list in Excel?

I have an excel spreadsheet with drop lists for pick and choose what criteria
I want entered in this column. I need to CHANGE the list (criteria) - how do
I do that?
--
Webgirl

  #2   Report Post  
Old May 19th 05, 08:32 PM
PC
 
Posts: n/a
Default

Data/Validation

Use/modify the list reference in "Select From List"

HTH

PC


"Webgirl" wrote in message
...
I have an excel spreadsheet with drop lists for pick and choose what

criteria
I want entered in this column. I need to CHANGE the list (criteria) - how

do
I do that?
--
Webgirl



  #3   Report Post  
Old May 23rd 05, 01:07 PM
Webgirl
 
Posts: n/a
Default

I need to clarify -

If you go to DATA/VALIDATION - there is nothing to modify. These are linked
sheets- the sheet I need to modify is sheet 3 - which links to sheet 7. How
do I change that table?
--
Webgirl


"PC" wrote:

Data/Validation

Use/modify the list reference in "Select From List"

HTH

PC


"Webgirl" wrote in message
...
I have an excel spreadsheet with drop lists for pick and choose what

criteria
I want entered in this column. I need to CHANGE the list (criteria) - how

do
I do that?
--
Webgirl






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A user says he can't get my drop down list to work in Excel. Keli Excel Discussion (Misc queries) 1 April 26th 05 08:22 PM
how do i create a find function for an excel drop list? RC Excel Discussion (Misc queries) 3 March 18th 05 03:09 PM
Drop Down List Sandy Excel Worksheet Functions 3 January 11th 05 10:50 PM
formatting drop down list dennis Excel Discussion (Misc queries) 2 January 11th 05 04:21 PM
Drop List Referencing Boony Excel Worksheet Functions 2 November 11th 04 11:42 AM


All times are GMT +1. The time now is 12:57 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017