Setting data validation drop-down menu to achieve the 3 cell methods

2010-09-09  来源:本站原创  分类:OS  人气:135 

Setting data validation drop-down menu to achieve the 3 cell methods

A direct input:
1. Select the cell to be set, such as cell A1;
2. Select the menu bar of the "Data" → "validity" → a "data validation" pop-up window;
3. In the "Settings" option in the → "validity conditions" → "allow" select "Sequence" → right "ignore null values" and "drop-down menu to provide" all the tick → in the "source" the following input data such as "1,2,3,4,5,6,7,8,9" (without quotation marks, separate symbol, "" must be half-width mode) → press "OK" on OK, and once again select the A1 cells appeared in the drop-down menu.

Second, the reference data within the same worksheet:
If the same worksheet is a column of data you want the drop-down menu, such as reference worksheet Sheet1, B2: B5, B2: B5 were the following data: 1,2,3,4, as follows:
1. Select the cell to be set, such as cell A1;
2. Select the menu bar of the "Data" → "validity" → a "data validation" pop-up window;
3. In the "Settings" option in the → "validity conditions" → "allow" select "Sequence" → right "ignore null values" and "drop-down menu to provide" all the tick → in the "source" the following input data "= $ B $ 2 B $ 5", also can be the right choice with a red arrow in the direct B2: B5 Regional → click "OK" on OK, and once again select the A1 cell, the drop-down menu will appear.

3, reference different worksheets within the data (to be used in the definition of names):
If different worksheet is a column of data you want the drop-down menu, such as worksheets, Sheet1, cell A1 to reference a worksheet Sheet2 of B2: B5 area worksheet Sheet2 in B2: B5 were the following data: 1,2 , 3,4, the operation is as follows:
1. Definition Name: Menu Bar → "Insert" → "name" → "the definition of" → pop-up "definition name" window, "in the current workbook in the name of the" Enter "DW" (you can easily own obviously) → " reference position "Enter" = Sheet2! $ B $ 2 B $ 5 ", also can be the right choice with the red arrows direct B2: B5 Regional → press" Add "then click" OK "to complete the first step.
2. Select the menu bar of the "Data" → "validity" → a "data validation" pop-up window;
3. In the "Settings" option in the → "validity conditions" → "allow" select "Sequence" → right "ignore null values" and "drop-down menu to provide" all the tick → in the "source" Enter " = DW "," DW "is just the definition of a good name, and click" OK "on OK, and once again select the A1 cell, the drop-down menu will appear.

The third case can also be done: first, anywhere in Sheet2 input value, then the upper left corner (below the left toolbar) Enter the name of the custom area such as: AA, then need to refer to a place in the Sheet1, in accordance with the above third step to do, "the source of" input "= AA" can be.

3 above is complete the simplest method of operation can also use VBA programming.

In 2007 and 2010 can directly enter the formula: "= table name! Reference cell: the cell reference." "= Sheet1! $ A $ 1: $ A $ 10".

Q: How effective sequence in the data tables referenced in other range of cells?
A: Select the cell data validation settings, click the "Data" tab → → data validation dialog box that pops up the "Settings" tab, set the "Allow" entry to "sequence", in source edit box, directly enter the required forms and other referenced address range of cells, such as "= Sheet1! $ A $ 1: $ A $ 10". But can not use the edit box of the Select button to select the range of cells directly across the table.

相关文章
  • Setting data validation drop-down menu to achieve the 3 cell methods 2010-09-09

    Setting data validation drop-down menu to achieve the 3 cell methods A direct input: 1. Select the cell to be set, such as cell A1; 2. Select the menu bar of the "Data" → "validity" → a "data validation" pop-up window; 3. In

  • Summary data validation struts2 2010-08-23

    struts2 validation of data is the type of conversion after struts2, and gives the following example: 1, the preparation of register2.jsp, allow customers to input data, the code is as follows: <body> <table align="center" width="30

  • Struts2 validation framework of data validation framework 2010-10-19

    struts2 core is the evolution from the webwork, and the data validation framework is actually a set of things that the original webwork. A, Struts2 framework describes the overall data validation struts2 in action must succession ActionSupprot class

  • data validation struts2 2010-10-20

    struts2 core is the evolution from the webwork, and the data validation framework is actually a set of things that the original webwork. A, Struts2 framework describes the overall data validation struts2 in action must succession ActionSupprot class

  • 2个 Admin Drop Down Menu 帮助你增强Wordpress后台体验 2015-02-15

    Wordpress2.5后台简直是糟糕至极.与以后不同的手势.Sidebar Widgets的隐藏.插件与setting的不明确,等等,都让WPer感觉非常不适应.所以有了类似于"Why I hate WP2.5"这样的文章.幸运的是,Wordpress就像一个大家庭,一有问题,大家都在想办法,聪明的WPer制作了以下两个插件,两个让你的后台明朗起来,并节省你时间,且绝对值得拥有的插件. 对于下面这两个插件,你只要选择其中之一就可以了,他们有一样的名字,一样的功能,不同的更多只是体验和

  • javascript data validation js legal validation. js email verification. js url validation. js length of the authentication. js digital certification, etc. (pop-up dialog box form) 2009-01-06

    javascript data validation js legal validation, js email validation, js url validation, js length of the validation, js digital certification, etc. (pop-up dialog box form) 2008-11-07 02:51 / ** * To be in English and Chinese characters long * @ Para

  • President: dwell on Silverlight 3.0 in the data validation (Silverlight Validation in Detail) 2010-03-18

    In a previous post where I mentioned the Silverlight 3 enhances the support of the data entry validation. In this small, special counseling, I will take you to experience the implementation details of the whole process of validation. Silverlight is t

  • JavaScript data validation and testing 2010-03-29

    1. Data Validation //*** Determine whether the integer *** / function check_int (obj) ( var patrn = / ^ [0-9]? [0-9] * $ / if (patrn.exec (obj.value)) return true; showmsg (obj, "Please enter a number!"); return false; ) //*** Determine whether

  • CakePHP for data validation (validate) Set 2010-08-09

    In CakePHP, the data for model validation is very simple, here I am in the Blog Model is used in authentication methods: /** * Blog validate rule * * @var array * @access public */ var $validate = array( 'title'=>array( 'notEmpty' => array( 'rule' =

  • Asp.net MVC2 data validation study notes (front and back unified authentication) 2010-10-04

    Validate user input in the web system is sure to be frequently used, for example, the input can not be blank or enter the characters in a certain range and so on. . Most of the time we use Javascript to validate the front of the user's input, in fron

  • Flex data formatting and data validation 2010-11-05

    Flex data formatting and data validation Formatter class Formatter class in the Flex framework. This class will format the data into a string. All classes are mx.formatters.Formatter formatting subclass, including: · CurrencyFormatter (formatting cur

  • Interface design data validation 2011-07-01

    Interface design data validation 1, the interface need to return to verify the success, you can use true and false. 2, interface validation if unsuccessful, the need to return a message, you can string representation. 3, interface verification messag

  • Some data validation J2EE development proposals 2011-08-30

    Said in front of: non-original. Input data validation: Although convenient for the user, can provide a "client" layer of data validation of data, but must use the Servlet to perform validation at the server level. Client-side validation itself i

  • Mac-Style Drop Down Menu 2008-09-19

    Mac-Style Drop Down Menu 网站 : http://jquery.com/ Description This plugin dynamically skin default form's drop down menu, i.e. <select>, of choice as if rendered on Safari browser; thus, the name: Mac-Style Drop Down Menu. In a general sense, the plu

  • yet another drop down menu 2008-09-19

    yet another drop down menu 网站 : http://jquery.com/ drop down menu with filter capability. the user can type several chars and the list will be automatically filtered showing only those that contain the typed chars. page in spanish 授权协议: 未知 操作系统:

  • jQuery下拉菜单插件 jQuery Simple Drop Down Menu 2009-02-14

    jQuery Simple Drop Down Menu 网站 : http://javascript-array.com/scripts/jquery_simple_drop_down_menu/ 这是一个非常简单的jQuery下拉菜单插件,如下图所示 授权协议: 未知 开发语言: JavaScript 操作系统: 跨平台

  • iOS 下拉菜单 Drop Down Menu 2012-08-29

    Drop Down Menu 网站 : https://github.com/dongle/DIYMenu DIYMenu 实现弹出下拉菜单效果.当点击菜单某个选项时,菜单又会收缩隐藏回去.具体效果请看视频. [Code4App.com] 授权协议: Apache 开发语言: Objective-C 操作系统: iPhone/iPad/iPod

  • Better form data validation package 2010-04-08

    /***** ***** Validate form data form ***** ***** ********/ function CheckForm (oForm) ( var els = oForm.elements; / / Loop through all table elements / / Alert (els.length); for (var i = 0; i <els.length; i + +) ( / / Alert (els [i]. GetAttribute (&quo

  • Struts2 dynamic data validation on the echo problem 2010-04-28

    struts2 for the server-side validation, can be used two kinds of, 1: rewrite the validate method, 2: The validate framework, let us look at validate method, the following diagram as an example. Figure marital status and gender requirements dynamicall

  • JavaScript data validation methods commonly used 2010-03-29

    / ** * Drop-down list will be spliced together all the elements * / function getAllOptions (comName) ( var com = document.getElementById (comName); var len = com.options.length; var values = ""; var texts = ""; for (var i = 0; i <le