| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Add a number to multiple cells
I want to add 1 to a number of cells at one time. How can I do this?
|
|
#2
|
|||
|
|||
|
Add a number to multiple cells
Enter the 1 in some blank cell and copy that cell. Then select
the cells to which you want to add 1. Finally, go to the Edit menu, choose Paste Special, and choose the "add" operation. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Matt" wrote in message ... I want to add 1 to a number of cells at one time. How can I do this? |
|
#3
|
|||
|
|||
|
Add a number to multiple cells
Matt
Copy a 1 and then highlight the data and do EditPaste special...Values+Add -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Matt" wrote in message ... I want to add 1 to a number of cells at one time. How can I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to delete blank cells across multiple columns? | Excel Worksheet Functions | |||
| Converting a link to values to multiple cells. | Excel Worksheet Functions | |||
| Adding separate accumulators for multiple cells | New Users to Excel | |||
| How to link cells and keep number format altogether | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
Linear Mode
