Adding a number to a large group of data

Hi,
I have a problem which I think will be very basic but I cant think on how I would get on about getting it sorted. I have a large group of data and I want to add a number to every number within the group. The number to be added will be the same for all data.

Example:

Data: 1 2 3 4 5 6 7

And I wish to add "5" to all of the data. So the desired result would be

Result: 6 7 8 9 10 11 12

Does anyone have an easier way to do this than manually updating every box?

Many thanks in advance for all your help!!

Regards,
Ryan

Ryan

In a blank cell somewhere, enter the number 5. Then copy that cell. Highlight the original data, then go pastespecial, add. This will add the 5 to each number in the highlighted range. Remember to delete the 5 from the temp cell.

HTH

rylo

That has worked a treat. Thank you very much for your help guys!!