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

Ad by

这里有人会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)

@Calgary

这里有人会Excel 吗？

Replies, comments and Discussions:

More Topics