Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Batch Add Units to Cells in Excel

Date:2022-8-2 Author:Sandra

There is a list of numbers, and you need to add units to each cell. Will you add these units one by one?  However, if there are too many cells, the manual method will be cumbersome. Now, we are going to learn a trick to batch add units to cells.

Let’s take “kg” as an example, you can change the units as your need.

How to Batch Add Units to Cells in Excel

Highlight these numbers and press the Ctrl and 1 to quickly open the Format Cells window.

How to Batch Add Units to Cells in Excel

Go to the Custom in the category list.

Type “0kg” and hit OK.

How to Batch Add Units to Cells in Excel
How to Batch Add Units to Cells in Excel

By the way, if you calculate these numbers. The result will also have unit.

How to Batch Add Units to Cells in Excel
How to Batch Add Units to Cells in Excel
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *