If there is a list of numbers in your worksheet and you want to add a unit to each cell, you can add units to each cell manually. However, if the cells in the list are too many, the manual method will be tedious. Stay tuned and use the available tool to add units to cells in Excel.
How to add unit to cell in Excel
Guide to add unit to cell in Excel
- 1. Quick Start Guide
- Open the File sheet with Excel => Select the sheet to add units => Right-click => Select Format Cells => In the Category section, select Custom => Enter the number 0 => Type the unit you want to add next to it, for example 0 “fruit” => Click OK.
2. Detailed instructions for adding units to cells in Excel
Step 1: Open your File Sheet with Excel.
– For example, we have the following file:
Step 2: Black out the column we need to add units
– Right-click and select Format Cells.
Step 3: In the Category section, we select Custom. Then you enter the number 0 with the unit in the Type field. For example, we enter 0 “fruit” in the Type field.
– Note: spaces and quotation marks are required in the unit you want to add.
Step 4: Click OK.
– After clicking OK , the result will be as shown below.
https://thuthuat.taimienphi.vn/cach-them-don-vi-vao-o-trong-excel-70640n.aspx
Above is an article showing how to add units to cells in Excel to help you add those units that Excel is not available. In the course of using Excel, you can also