Home >Topics >excel >How to add a custom sequence in excel

How to add a custom sequence in excel

醉折花枝作酒筹
醉折花枝作酒筹Original
2021-05-12 15:02:2860219browse

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".

How to add a custom sequence in excel

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.

How to add a custom sequence in excel

How to add a custom sequence in excel

Call up the excel option box.

How to add a custom sequence in excel

Click Advanced and find Edit Custom List.

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

How to add a custom sequence in excel

How to add a custom sequence in excel

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

How to add a custom sequence in excel

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn