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

How Do I Add 10 To All The Cells in Excel

Date:2021-6-11 Author:Sandra

Do you know how to add  or subtract 10 from all the cells? I mean at the same time. If you haven’t mastered this technique yet, read on.

Now we open an Excel sheet and enter some random numbers. Let’s take 10 as an example. Just type 10 in any cell.

How Do I Add 10 To All The Cells in Excel

Select 10 and press Ctrl and C to copy it. Then highlight the random number area first and right mouse click. Choose Paste Special in the list.

How Do I Add 10 To All The Cells in Excel

In the Paste Special box, you can choose Add, Subtract, or even Multiply and Divide. Then hit Ok.

How Do I Add 10 To All The Cells in Excel

Each number in the cell has been added 10 quickly.

How Do I Add 10 To All The Cells in Excel
How Do I Add 10 To All The Cells in Excel

That’s all for today’s tutorial. It’s simple but useful.

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 *