>Hi
>
>if I want to increment an entire column by one in excel2007.
>
>How I would do that.
>
>Nick
You mean, add one to the values? Copy and paste special, as follows:
Type 1 in a cell
Select it and press Ctrl-C
Select the destination range
Right-click, select "Paste special", and select the "Add" option.
This works both for cells that have only values, and cells that have formulae - in the case of formulae, "+1" would be added at the end.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
