excel导入数据校验
I've finally updated my Data Validation intro video, so it shows the steps for creating a drop down list in Excel 2010, instead of Excel 2003. These instructions apply to Excel 2007 too, in case you're using that version.
我终于更新了我的数据验证简介视频,因此它显示了在Excel 2010(而不是Excel 2003)中创建下拉列表的步骤。这些说明也适用于Excel 2007,以防您使用该版本。
In honour of this momentous occasion, here are links to a few of my previous Excel Data Validation articles and posts. You probably know all the basics, but maybe you've missed a few of these tips and tricks.
为了纪念这一重要时刻,这里提供了一些我以前的Excel Data Validation文章和帖子的链接。 您可能知道所有的基本知识,但也许您错过了一些提示和技巧。
Show or Hide User Tips In Excel – AlexJ shows how to let users turn data validation messages on or off, by choosing TRUE or FALSE from a drop down list.
在Excel中显示或隐藏用户提示 – AlexJ显示了如何通过从下拉列表中选择TRUE或FALSE来使用户打开或关闭数据验证消息。
Dependent Data Validation From a Sorted List – Select an item in the first drop down list, and related items are shown in the second drop down list.
从排序列表中进行从属数据验证 –在第一个下拉列表中选择一个项目,相关项目显示在第二个下拉列表中。
Limit the Total Amount Entered in Excel - use Data Validation to limit the total amount that users enter in a group of cells.
限制在Excel中输入的总金额 -使用数据验证来限制用户在一组单元格中输入的总金额。
Select Multiple Items from Excel Data Validation List - instead of selecting just one item from a data validation drop down, you can select two or more.
从Excel数据验证列表中选择多个项目 -您可以选择两个或多个,而不是从数据验证下拉列表中仅选择一项。
Plan Your Party Seating with Excel - too late for Christmas dinner, but this might help with your New Year's festivities.
使用Excel计划您的聚会座位 -来不及参加圣诞大餐,但这可能有助于您新年的庆祝活动。
Note: Remember to vote for the Excel functions that you'd like to learn more about during the 30 Excel Functions in 30 Days challenge, starting January 2nd.
注意 :请记住, 在 1月2日开始的30天30天Excel功能挑战赛中,投票给您想了解更多的Excel函数 。
观看Excel 2010下拉列表视频 (Watch the Excel 2010 Drop Down List Video)
The shiny new video is below, in case you'd like to see that too.
如果您也想看下面的新视频,该视频会亮着。
翻译自: https://contexturesblog.com/archives/2010/12/27/excel-data-validation-update/
excel导入数据校验