How to add values to multiple cells in Excel?
Adding a value to multiple cells in Excel can be done swiftly and efficiently using the right methods. This guide will introduce you to several techniques that simplify the process, ensuring you can update your data quickly and with ease.
Add value to multiple cells with VBA
Using macros can ease many repeated processing, and make our work easier and faster. So does the following macro.
Step 1: Select the cells that you will add value to.
Step 2: Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.
Step 3: Click Insert > Module, and paste the following VBA in the Module Window.
VBA code: Add value to selected cells in Excel
Sub Add2Formula()
'Updated by Extendoffice 2024/07/23
For Each c In Selection
c.Activate
ActiveCell.FormulaR1C1 = "= " & ActiveCell.Formula & "+300"
Next c
End Sub
- This macro is only valid for cells containing no formulas within them.
- This macro will add 300 to all selected cells. If you want to add another value, please replace the 300 with another value.
Add value to multiple cells with Kutools for Excel
Kutools for Excel provides us with an alternate easy-to-use method, and its Operation feature can help us add value to multiple cells easily.
Step 1: Select the cells to which you will add the same value.
Step 2: Click the Kutools > More > Operation.
Step 3: Select the Addition from the Operation section, and enter the value you will add to the selected cells. See screenshot:
Step 4: Check the Create formulas option.
Step 5: Click OK.
![]() | In Operation, | ![]() |
Kutools for Excel's Operation feature supports all kinds of mathematical operations to all selected cells together:
- Addition: Plus a specified operand.
- Subtraction: Subtract specified operand.
- Multiplication: Each value of cells is multiplied by the operand.
- Division: Each value of cells is divided by the operand.
- Exponentiation: Each value of the cell powers the operand.
- Rounding: Round each value of a cell to the decimal numbers (specified operand).
- Function: Applies a function to each value of a cell.
- Custom: Create a formula-like expression and apply it to each value of a cell.
Related Article
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!
![Screen Shot of Excel (with Office Tab installed)](http://cdn.extendoffice.com/images/stories/kte-module/officetab-bottom-02.gif)
![Taher](http://cdn.extendoffice.com/media/com_easydiscuss/images/default_avatar.png)
![Joe Riter](http://cdn.extendoffice.com/media/com_easydiscuss/images/default_avatar.png)
![Hum3](http://cdn.extendoffice.com/media/com_easydiscuss/images/default_avatar.png)
![sharfudheen](http://cdn.extendoffice.com/media/com_easydiscuss/images/default_avatar.png)
![Fazlan](http://cdn.extendoffice.com/media/com_easydiscuss/images/default_avatar.png)