numbering

S

Scorpio

I don't know how to explain this but I'll try...I am doing a spreadsheet and
on the first column i want numbers but I don't want to have to write the
numbers ex: 1st row 1
then 2 ans so on can I format it so I don't have to type the numbers out all
the time.

I hope I explained it wel...
 
P

Pecoflyer

Scorpio;210140 said:
I don't know how to explain this but I'll try...I am doing a spreadshee
and
on the first column i want numbers but I don't want to have to writ
the
numbers ex: 1st row 1
then 2 ans so on can I format it so I don't have to type the number
out all
the time.

I hope I explained it wel...
Click to expand...

Hi,
the row numbers are already there, but if you need them in col A f.i
enter 1 in A1, 2 in A2, select both cells and drag down as needed
there are other ways

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste
 
D

David Biddulph

A number of ways, including:

=ROW()
1 in A1 then =A1+1 below & copy down
1 in A1, 2 in A2, select & fill down.
 
M

Marcelo

to print Row and column headings,

go to file - page setup - sheet and flag it

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Scorpio" escreveu:
 
Top