Thank you so much for this. I've been struggling with this and you made it
so simple. This is the answer to a question I keep asking folks. Thx a
million

"JeriSys" wrote:

Thanks!!!


"bj" wrote:

simplest way is to enter 1 inot an empty cell. copy that cell select tge
column and paste special -add

"JeriSys" wrote:

If I have a column of numbers and I want to increase each number in that
column by 1, how do I do that? THANX!!