Instructions for adding units to cells in Excel quickly

 70 total views


In the process of using Excel, many times you will encounter cases where you have to compose calculations with additional units behind such as currency, measurement unit. But the characters you want to fill are not available in Format Cells. Follow this article to know how to add units to cells in Excel.

If there is a list of numbers in your worksheet and you want to add a unit to each cell, you can manually add the unit to each cell. However, if the cells in the list are too many, the manual method will be very tedious. Follow along and let taimienphi use the available tools to add units to cells in Excel.

How to add units to cells in Excel

Instructions for adding units to cells in Excel

1. Quick Guide
Open File sheet with Excel => Select the table to add units => Right click => Select Format Cells => At Category, select Custom => Enter 0 => Type the unit you want to add next to, for example 0 “fruit” => Click OK.

2. Detailed instructions for adding units to cells in Excel
Step 1: Open File Sheet yours is equal to Excel.
For example, we have the following file:

how to add computers in excel

Step 2: Highlight column we need more units

how to add them in excel

– Press right mouse choose Format Cells.

how to add vi in ​​excel

Step 3: Section Categorywe choose Custom. Then you fill in number 0 attach unit section Type. For example: we enter 0 “fruit” in the field Type.
Note: space and quotation marks are required in the unit you want to add.

The fastest way to add them to excel

Step 4: Press OK.

guide them to work in excel

– After pressing OK The result will be like the image below.

meow them don't work in excel

https://thuthuat.taimienphi.vn/cach-them-don-en-vao-o-trong-excel-70640n.aspx
Above is an article on how to add units to cells in Excel to help you add units that Excel does not have. In the process of using Excel, you can also quickly delete empty data cells in Excel For precise alignment, easy on the eyes.

Related keywords:

How to add units to cells in Excel

, add units to Excel, Instructions for adding new units in Excel. Add new units to Excel.,

Close Bitnami banner

Related Posts

Leave a Reply

Your email address will not be published.

%d bloggers like this:
Ads Blocker Image Powered by Code Help Pro

Support our free content

It\'s a beautiful day for an ad, please support rvgamepc by disabling your ads blocker <3

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock
Close Bitnami banner
Bitnami