How to add book title numbers to cells in batches in WPS table How to add book titles in batches in Excel

There are many practical functions in WPS. You can edit data and text in table documents, and you can also use formulas, formatting tools, etc. to edit. If you want to add book titles to table documents in batches, how should you do this? Next, the editor will share with you the method. Setting method 1. We first right-click a table document, then click the Open with option in the menu list, and then select the WPS office option in the submenu list.

2. After entering the WPS page, we select all the cells where we need to add the book title number, then right-click and select the Format Cell option.

3. After entering the setting cell format page, we first click to open the custom option in the number page.

4. Then on the customization page, we enter "@" in the type box, and then click OK.

5. After the setting is completed, we can see in the table that all the selected cells have book title numbers added.

The above is the detailed content of How to add book title numbers to cells in batches in WPS table How to add book titles in batches in Excel. For more information, please follow other related articles on the PHP Chinese website!