Recently, the higher authorities asked us to conduct a data collection and sent us an information collection form in .xlsx format. Because of the huge amount of information to be collected, in order to improve the collection, we distributed the collection form to each group to fill in, which involves collaborative sharing, and the summary of the data recovery of each group. The following system home Xiaobian tells you how to complete the same task through the related functions of Excel and the division of labor. The table structure and filter data of the original workbook of the protection worksheet cannot be changed privately, so relevant protection (Excel 2010 or above) is required. After selecting the entire worksheet, right-click to open the “Set Cell Format” dialog box, switch to the “Save” tab, cancel the “Lock” option, and return to OK. Then select the cell area that needs to be protected and limit editing. You can use the Ctrl or Shift key to perform the check. Same as above, enter the “Setting the cell format” “protect & rdquo; tab, and check “ ”. Switch to “review""change"change" function group<;protect worksheet", in the pop-up "protect worksheet" dialog box, it has been automatically checked "protect the worksheet and The locked cell content & rdquo; item, then refer to the icon to set up (Figure 1), need to be reminded that the "edit object" and "editing program" rdquo; two check boxes can not be selected, after confirmation Take effect (be careful not to forget to set a password). In this way, the locked area will not be modified. Set the shared workbook to open the original workbook, for example, “2011-2012 academic year teacher continuing education verification information collection form.xlsx”, click “Change” "Change group" "share workbook>; check “ Allow multiple users to edit at the same time, while allowing the workbook to merge & check box (Figure 2), it will take effect after confirmation. Add “Compare and merge workbooks” Because the "Change" tab"change" feature group does not provide a comparison workbook feature, but we can add it to the quick access toolbar: from the Office button Open the “Excel Options” dialog box, in the "Customized List"" from the following location, select the command" list, click to select “all commands", find in the list “ compare and merge Workbook & rdquo;, double-click to add to the list box on the right, after confirming, you can add this button to the Quick Access Toolbar. Note that this button is grayed out if the workbook is not shared. Make a copy of the shared workbook to copy or save several original workbooks separately. In order to distinguish it from the original workbook, it is recommended to add the names such as “-mechanical group”,“-electronic group” at the end of the file, for example “2011-2012 academic year teacher continuing education verification information collection form - mechanical group.xlsx”, sent to each group to fill out. After the work is much simpler, after receiving the corresponding copy of the shared workbook, focus the copy files on the same folder path as the original workbook, and click “Compare and merge workbooks” on the Quick Access toolbar. Button, you will be prompted to save the document, click the "OK" button, after saving the document will pop up a dialog box (Figure 3), here to load a copy of the workbook provided by each group, confirm the completion of the merger operation. This article comes from [System Home] www.xp85.com