Home  >  Article  >  Software Tutorial  >  How to add book title numbers to cells in batches in WPS table How to add book titles in batches in Excel

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

WBOY
WBOYOriginal
2024-09-03 15:14:02621browse

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.

WPS表格怎么给单元格批量添加书名号 Excel批量添加书名方法

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.

WPS表格怎么给单元格批量添加书名号 Excel批量添加书名方法

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

WPS表格怎么给单元格批量添加书名号 Excel批量添加书名方法

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

WPS表格怎么给单元格批量添加书名号 Excel批量添加书名方法

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

WPS表格怎么给单元格批量添加书名号 Excel批量添加书名方法

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!

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