How to add a custom sequence in excel

Add method: First open the excel table, click "File" - "Options" at the top of the page to bring up the "excel options" box; then select "Advanced" and find "Edit Custom List"; then in In the pop-up "Custom Sequence" dialog box, click "Add" and enter the new sequence; finally click "OK".

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Open the excel table and click the File-Options command.

Call up the excel option box.

Click Advanced and find Edit Custom List.

The custom sequence dialog box pops up, click Add, enter one by one, and confirm.

Finally enter it in the excel sheet and see the final effect.

Related learning recommendations: excel tutorial

The above is the detailed content of How to add a custom sequence in excel. For more information, please follow other related articles on the PHP Chinese website!