3 methods to add unit to cells in Excel - a step-by-step guide
In Excel, adding units to cells can be crucial for clarity and context, especially when dealing with quantities or measurements. This tutorial explores three methods to achieve this: using the Format Cells function, leveraging Kutools for Excel for efficiency, and employing formulas for dynamic unit inclusion.
Add unit to each cell with Format Cells function
As shown in the screenshot below, if you need to append the unit 'kg' to a list of quantities without influencing their underlying calculations, the Format Cells function in Excel offers a practical solution.
1. Select the data list, then right click to select Format Cells from the context menu.
2. In the popped out Format Cells dialog and under the Number tab, select Custom from the Category list, and then in the Type text box, enter 0"kg" into it. Finally click OK.
Easily add unit to each cell in selection with Kutools for Excel
If you simply want to add units to cells without thinking about calculations, Kutools for Excel offers a straightforward solution with its 'Add Text' feature. This tool allows you to quickly append units like 'kg' to quantities in your spreadsheet.
After downloading and installing Kutools for Excel, click Kutools > Text > Add Text to open the Add Text dialog box. Then you need to configure as follows.
- Select the list of cells to which you want to add unit.
- In the Text box, type the unit you need into it. such as " kg" in this case.
- Select the After last character option in Add position section.
- Click OK to apply the feature.
Result
The specified unit is added to each cell in the selected range immediately.
Add unit to each cell with formula
If you simply want to add units to cells without thinking about calculations, you can also use the "&" operation to accomplish this task.
Select a blank cell next to the fist cell of the data list, and enter this formula =B2&"kg" (B2 indicates the cell you need its value, and $ is the unit you want to add to) into it, and press Enter key, then drag the AutoFill handle to the range.
Relative Articles:
- Add/ insert prefix or suffix to selected cells, rows, and columns
- Add percentage symbol for multiple numbers in cells
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
