Add Number to Multiple Cells in Excel
If you’ve already entered a number in a cell, or a group of cells, what’s a quick way to add something to that amount?
For example, I keep track of my To Do list in a workbook, and one of my items is “Daily Admin tasks”. Sometimes, I start the day by answering client emails, posting links to my latest blog post, and doing the accounting for the previous day’s sales.
So, I enter the time spent – 0.75 hours – and move on to the next task.
Later in the day, I might spend another 45 minutes on Admin tasks, so I want to add that to the previous amount, in cell D5.
If it’s late in the day, it might be difficult to add 0.75 + 0.75 in my head (or early in the day, if I haven’t had my coffee yet!)
Use Paste Special
One way to do this, and avoid basic mistakes in arithmetic, is to use Paste Special – Add.
- Type the number in a cell, and copy that cell.
- Then, use Paste Special – Add, to paste that amount into another cell.
That technique works well, but it takes a few steps – and that adds more time to my Admin tasks!
Use a Macro to Add Amounts
To make the job easier, I created a couple of macros that add numbers to selected cells. There is a link to the download page, at the end of this article.
- Macro 1 adds a set number to the selected cells.
- Macro 2 asks you to enter a number, then adds that number to the selected cells.
In the macro code, I use 7 as the set number, and the default number, because I have several weekly tasks. Once they’re completed, I add 7 to the date, to move them to next week’s schedule.
You could change the code, so the set/default number is something that you use frequently.
Video: Add Numbers to Multiple Cells in Excel
Watch this video to see how to use the Paste Special command, and see how to modify the macro code, to change the numbers.
Or watch on YouTube: Add Number to Multiple Cells in Excel
Download the Sample File
To see how the macros work, and get the code to use in your own files, you can visit my Contextures website. You’ll find the instructions and sample file on the Add Number to Multiple Cells page.
The zipped file is in xlsm format, and contains macros. Enable macros when you open the file, if you want to test the code.