WPS 2009 Automatic Fill Rule Skill Summary

1, the default fill rule: wps to "number" by default to fill the sequence, to the "text + number" combination, text default copy fill, the number by default as a sequential way to fill.

2, Auto Fill in the role of <CTRL> key: Hold down the <CTRL> key while dragging the cell, whether it is a "number" or "text + number" combination, will be copied to fill the way.

3, right key fill: You can use the right button to drag the cell fill, and then in the right-click shortcut menu to select the fill, or even go to the "Sequence" dialog box for more detailed settings.

4, double-click Fill: In the data area to fill a column of data, only in the first cell or range of cells fill in the sample data, and then double-click the selected cell or range of cells fill handle can be automatically populated, The position to populate the last cell depends on the position of the last empty cell in its reference column (closest to the left or right column of the Fill column).

5, custom sequence fill: Sometimes the user wants to fill in their own way, et can't meet the user's requirements, then the "Custom sequence fill" can be used to solve the problem. such as "Chairman-General Manager-Deputy general manager-leader-deputy leader-staff" to fill, click the Menu Tool---options, enter the preceding sequence in the input sequence in the Custom List tab of the Options dialog box, and after clicking Add and OK, Can be populated with a newly defined sequence.