Basic steps for adding units in batches in Excel

Time: 2022-02-22Source: Huajun Software TutorialAuthor: dim sum

Recently, some novice friends have consulted the editor about the related operations of adding units in batches in Excel. The author below will specifically provide the basic steps for adding units in batches in Excel. I believe it will be helpful to everyone.

If it is the RMB amount symbol, it is very simple. Just select this column and hold down CTLR+SHIFT+4 to quickly add it.

If it is a percentage, then CTLR+SHIFT+5 will do.

If you want to add Chinese units after the numbers, then we can select this column of cells, right-click to set the cell format, and in the customization in the category, enter 0+units. Here we use yuan as an example.

Finally, click OK, and units will be added after all numbers. If the unit is added in front, the operation is still the same, except that the unit is added in front of 0.

The above is the basic steps for adding units in batches in Excel that the editor explains to you. Let’s learn together. I believe it can help some new users.

Related articles更多>>

• Tutorial on how to extract relevant records based on conditions from data in Excel tables
• Introduction to the simple operation of freezing specified rows and columns in Excel
• A simple explanation of how to change colors between rows in Excel
• Detailed steps for copying charts in Excel
• Detailed steps to filter and delete duplicates in Excel
• Explanation of the basic steps for checking the sign-in sheet in Excel
• Detailed explanation of the use of IF function in Excel
• Introduction to how to quickly align decimal points in data settings in Excel tables
• Detailed steps for Excel to use vlookup to find items
• Google Chrome downloads graphic and text operation content of web videos

Popular recommendations

• 

  My way PPT

  Version: 2.9.8 official versionSize: 67.7

  The official version of Wudao PPT is a small, full-featured slideshow production tool. This Wudao PPT software adopts a very simple and exquisite operation interface...

• 

  Microsoft OfficePLUS PPT plug-in

  Version: 4.3.5.10Size: 5.69MB

  PPT plug-in is a very popular PPT plug-in. The official version of Microsoft Office PLUS provides you with various high-quality PPT templates, practical PPT modules, and Word requests...

• 

  PowerPoint(PPT) 2016

  Version: 2016 official full versionSize: 4.62M

  Powerpoint2016 is a professional presentation software. Powerpoint2016 has a wide range of applications and is becoming an important part of people's work and life...

• 

  ppt slide software (powerpoint2003)

  Version: 2003 official versionSize: 4.6MB

  PowerPoint2003 official version is a document presentation tool often used in the office. The PC version of ppt slideshow software is used to create videos, audios, PPT...

• 

  Ali mailbox

  Version: 2.7.1.13834 official versionSize: 84.34MB

  The official version of Alibaba Mailbox supports standard protocol login, but you need to log in to the Alibaba Cloud Mailbox account as the main account first. The corporate email is suffixed with the corporate domain name...