How to add prefixes to WPS tables in batches and add prefixes to Excel in batches

When adding prefixes or suffixes in batches in a WPS table, the cell-by-cell operation is time-consuming and laborious. To this end, PHP editor Baicao provides three convenient methods to greatly improve work efficiency. This tutorial will introduce the steps of each method in detail to help users quickly master the skills of adding prefixes/suffixes in batches, thereby improving office efficiency.

1. Select the cell range and press Ctrl 1 at the same time to set the cell format. (Or right-click the mouse and select Format Cells)

2. Click [Customize], enter Finance Department-@ in the [Type] option, and finally click [OK] to complete!

2. Plug-in method

1. Download and install the Excel plug-in Square Grid.

2. Click the [Square Grid] option.

3. Select the cell range, select [Insert text], click [Insert text to the beginning], then enter the prefix information in the pop-up dialog box, click [OK] to complete.

3. Smart filling method

Note: This method is suitable for higher versions of Excel and WPS, lower versions of Excel do not have this function!

1. Insert an auxiliary column.

2. Enter the Financial Department - Han Ying in the auxiliary column cell, then click the mouse on the next cell and press [Ctrl E] at the same time to quickly fill it.

The above is the detailed content of How to add prefixes to WPS tables in batches and add prefixes to Excel in batches. For more information, please follow other related articles on the PHP Chinese website!