add 1 count to a column of numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
put the number 1 in an empty cell
copy that cell
select the list of numbers and
use Edit->Paste Special->Add
 
simplest way is to enter 1 inot an empty cell. copy that cell select tge
column and paste special -add
 
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
 
Back
Top