How to quickly add a prefix in Excel? How to add prefixes to Excel tables in batches

WBOY
Release: 2024-03-14 09:16:11
forward
856 people have browsed it

How to quickly add a prefix in Excel? How to add prefixes to Excel tables in batches. In Excel, sometimes it is necessary to add prefixes to a large amount of data to distinguish or mark them. At this time, how to quickly add prefixes in batches becomes a problem. This article will introduce several methods to quickly add prefixes in Excel, allowing you to easily meet your data processing needs. Whether you are working or studying, these methods can help you improve your work efficiency and make data processing more convenient and faster. Next, let’s take a look at the specific steps.

 How to quickly add a prefix in Excel?

1. Cell format method

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)

How to quickly add a prefix in Excel? How to add prefixes to Excel tables in batches

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

How to quickly add a prefix in Excel? How to add prefixes to Excel tables in batches

2. Plug-in method

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

How to quickly add a prefix in Excel? How to add prefixes to Excel tables in batches

2. Click the [Square Grid] option.

How to quickly add a prefix in Excel? How to add prefixes to Excel tables in batches

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, and click [OK] to complete.

How to quickly add a prefix in Excel? How to add prefixes to Excel tables in batches

3. Intelligent 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.

How to quickly add a prefix in Excel? How to add prefixes to Excel tables in batches

2. Enter "Finance 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.

How to quickly add a prefix in Excel? How to add prefixes to Excel tables in batches

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

Related labels:
source:xitongzhijia.net
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template