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 simplify repetitive tasks and make your work more efficient. The following macro demonstrates how to add values to multiple cells.
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- The macro can overwrite cell contents, so make a backup if needed.
- This macro works only for cells that do not already contain formulas.
- 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. Here, I entered the value 300. See screenshot:
Step 4: Check the "Create formulas" option.
Step 5: Click "OK".
 | >>> |  |
This 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!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite ā Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license ā set up in minutes (MSI-ready)
- Works better together ā streamlined productivity across Office apps
- 30-day full-featured trial ā no registration, no credit card
- Best value ā save vs buying individual add-in