Purchase Windows and Office keys with the discount code [KSW35]

Enjoy preferential price + extra 35% off = up to 90% DISCOUNT!
Take a Guess to Get Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Add a Number to All Cells in Excel

Date:2019-8-26 Author:Cordelia

While editing a spreadsheet in Microsoft Excel, you may encounter a situation which requires you to add a number to all cells in a column or a table. Doing the calculation manually and filling the cells one by one is apparently not the best idea. In fact, you can use Paste Special to achieve this goal within a very short time.

For example, now I want to add 30 to the scores of all the students in column C.

How to Add a Number to All Cells in Excel

Enter the number 30 in any of the cells beside column C.

How to Add a Number to All Cells in Excel

Press Ctrl+C to select this cell or right-click it and click Copy in the menu. Then select all the scores in column C.

How to Add a Number to All Cells in Excel

Switch to Home tab and click PastePaste Special… or right-click the selected cells in column C and choose Paste Special under Paste Options.

How to Add a Number to All Cells in Excel

How to Add a Number to All Cells in Excel

Choose Add in Operation in the popping out Paste Special window. Then hit OK to implement it.

How to Add a Number to All Cells in Excel

This number you entered will be added to all the cells in column C right away.

How to Add a Number to All 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 *