add 1 count to a column of numbers

J

JeriSys

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!!
 
D

Duke Carey

put the number 1 in an empty cell
copy that cell
select the list of numbers and
use Edit->Paste Special->Add
 
B

bj

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

Sunrich

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to count the numbers in a Word document? 0
Excel does not accept text format! 0
Autonumber field in Excel that behaves the same as Access 0
Section and Page numbering 0
How can the font and size of (all) citation numbers be altered? 1
Finding the proper style field and the numbered paragraph value within the style 0
Remove Identical words 0
Word- Find and Replace 1

Top