Add a number to multiple cells

[Matt]

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

[Chip Pearson]

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" <Matt@discussions.microsoft.com> wrote in message
news:2B590C30-F8DC-45EC-98BC-3DFDE0EFB4E6@microsoft.com...
>I want to add 1 to a number of cells at one time. How can I do
>this?

[Nick Hodge]

Matt

Copy a 1 and then highlight the data and do Edit>Paste special...>Values+Add

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Matt" <Matt@discussions.microsoft.com> wrote in message
news:2B590C30-F8DC-45EC-98BC-3DFDE0EFB4E6@microsoft.com...
>I want to add 1 to a number of cells at one time. How can I do this?