Add a number to multiple cells
 

I want to add 1 to a number of cells at one time. How can I do this?

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?

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?