> Because of work, I often want to subordinate units of the enterprise name into forever in a spreadsheet, rows of data in order to facilitate the backward counting, asks corporate leaders around the name to keep in line. Britain at the end of practice many times, I can invent a "data validation" function to solve this. pace / approach to work forever in office2004, open the appropriate spreadsheet. Switch to the "Worksheet 2" worksheet, the name of their business enterprise type (state-owned, collective, private ) were entered into a different cell line (Figure 1).direct"> Note: If the new business after intervention, as long as the name should be listed directly below the input phase of the cell can. select a column (name of state-owned enterprises listed site), then set the cursor in the" Name "column (in the" bar "on the left, see Figure 1), enter" state "character, then press" enter "key to confirm it. Hint: follow the above operation, b, c column named" collective , private. "and then switch to the" Sheet1 "worksheet, select the need to enter the" business type "area to the cell (such as d2: d100), the implementation of" data → validity "command, open the" Data Validation "For the dialog box (Figure 2) go to" Settings "tab, click" Allow "to the right of the drop-down button, select" sequence "option, then the following appears in the" source "box, enter" state-owned, collective, private "character, you're finished, to determine the return.direct"> Note: the above mentioned elements in the sequence between the condition of your use of commas in English. and then select the company name to enter the cell region-wide (eg, e2: e100), re-open." Data Validation "dialog box for, select the" sequence "option in the" source "box, enter the formula: = indirect(d1), determined to return. later when we fill in Company Name , first select the appropriate cell d columns (such as d3), then its right there in the drop-down button, click this button, then pops up in the drop-down list, select a "corporate type" (such as " collective "); then select e3 cell, the same drop-down button to the right click, you can type the company name from the appropriate list, select the desired corporate name (such as" b6 enterprise ") to fill the unit lattice (Figure 3). (责任编辑：admin)