Sometimes you might want to add units to cells in Excel.
While doing that manually might be a pretty time-consuming task, leveraging the ways we’re going to show you in this post will help you easily pull off the task – no matter how large your data set is.
Stick around to learn how to add units to cells in excel in two simple ways.
Method #1: Format Cells
This is the easiest way to add a unit of measure to each if you don’t want to use formulas.
1. Highlight a column list you want to add units.
2. Right-click to select “Format Cells…”.
![select format cells](https://spreadsheetdaddy.com/wp-content/uploads/2021/12/select-format-cells.png)
3. In the “Format Cells” dialog box, switch to the “Custom” tab.
4. Type “$”0 into the “Type” field.
5. Click “OK.”
![format cells type box](https://spreadsheetdaddy.com/wp-content/uploads/2021/12/fromat-cells-type-box.png)
Congrats! You’ve just added units to all of your selected cells.
![added units to cells](https://spreadsheetdaddy.com/wp-content/uploads/2021/12/added-units-to-cells.png)
Related Article: How to Fix the CTRL+F Search Shortcut Not Working in Excel
Method #2: The Formula
If you’re looking for a quick method to add units to your cells, you can do that by using a simple formula.
1. Select any empty cell next to your data set (B1).
2. Type =”$”&A1 into B1.
3. Drag the fill handle to copy the formula into the rest of the cells.
![add units using a formula](https://spreadsheetdaddy.com/wp-content/uploads/2021/12/add-units-using-a-formula.png)
Congratulations! In this tutorial, you’ve learned how to add units to cells in Excel!