This website requires Javascript to function properly. Please go to the setting of your web browser and enable Javascript for this website.

Ad by

推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

Ad by

推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

这里有人会Excel 吗？

23456789(大白乎)

急问：Excel Spreadsheet 怎样把Cell改成Drop Down List？ -23456789(大白乎); 15:55 (#941991@9)Reply

auto filter -7y7(醉里吴音); 15:57 (#941993@9)Reply

拜托，再详细一点点吗。在哪里找那个傲托？ -23456789(大白乎); 16:03 (#941999@9)Reply

data--> Filter --> Auto Filter -andy2060(胖胖猴：(|); 16:08 (#942002@9)Reply
Data -> Filter -> Auto Filter, not sure if this is what you want... -7y7(醉里吴音); 16:11 (#942007@9)Reply

不灵光，再来。给我送数据的mm麻玩艺不懂，就知道Y/N。我想给她一个Template，上面的cell已经有固定的选项让她选。这个这个选项好像搞不上去吗。谁知道？ -23456789(大白乎); 16:32 (#942018@9)Reply

(#3234817@0)
Last Updated: 2006-9-28
This post has been archived. It cannot be replied.

Report

Replies, comments and Discussions:

工作学习 / 专业技术讨论 / 这里有人会Excel 吗？ -23456789(大白乎); 2006-9-28 {625} (#3234817@0)
急问：Excel Spreadsheet 怎样把Cell改成Drop Down List？ -23456789(大白乎); 15:55 (#941991@9)Reply

auto filter -7y7(醉里吴音); 15:57 (#941993@9)Reply

拜托，再详细一点点吗。在哪里找那个傲托？ -23456789(大白乎); 16:03 (#941999@9)Reply

data--> Filter --> Auto Filter -andy2060(胖胖猴：(|); 16:08 (#942002@9)Reply
Data -> Filter -> Auto Filter, not sure if this is what you want... -7y7(醉里吴音); 16:11 (#942007@9)Reply

不灵光，再来。给我送数据的mm麻玩艺不懂，就知道Y/N。我想给她一个Template，上面的cell已经有固定的选项让她选。这个这个选项好像搞不上去吗。谁知道？ -23456789(大白乎); 16:32 (#942018@9)Reply

哼, 你不早说清楚: Data -> Validation, 然后随便你怎么给她做规矩了 -7y7(醉里吴音); 2006-9-28 (#3234830@0)

嘿嘿，不懂就不会说行话不是。 -23456789(大白乎); 2006-9-28 (#3234832@0)

Data > Validation > Allow (List) > Source: Options separated by a commas > OK -sonican(田园); 2006-9-28 (#3234839@0)
if you are using 2003, just right click the cell, then create list ... -alittleman(凡人); 2006-9-28 (#3234842@0)
嗯哪，骤是这个Data Validation就凑合拉。虽然不是真正意义的Drop Down，足以提醒mm乐。谢谢。 -23456789(大白乎); 2006-9-28 (#3234860@0)

@Florida

这里有人会Excel 吗？

Replies, comments and Discussions:

More Topics