Im using MIcrosoft Excel I wish to number Cells A5 - A36 with No..

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

Guest

I am using Microsoft Excel I wish to number cells A5 - A36 with the numbers 1
through 31 is there a formulae for doing this. ???
 
I am using Microsoft Excel I wish to number cells A5 - A36 with the numbers 1
through 31 is there a formulae for doing this. ???
Click to expand...

Microsoft's Help system has landed you in the wrong newsgroup: this
one is for the database program Microsoft Access.

Please use the dropdown box (the one that says "Access" by default)
to select a more appropriate newsgroup, such as
microsoft.public.excel.general.

Try "fill down" though...

John W. Vinson[MVP]
 
[Hi John - not sure that there is a group microsoft.public.excel.general
(not listed on my msnews server anyway)]

Hi

other alternatives are
microsoft.public.excel
or
microsoft.public.excel.newusers.

however, to answer the question - type the number 1 in A5 and the number 2
in A6, select both, now move the cursor to the bottom right hand cornerof A6
and you should see a +, hold your mouse down and drag to A36.

Cheers
JulieD
 
You must log in or register to reply here.

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

Have a value be shown as the referneced cell 17
Cell Reference in a Formula 2
IF statement & Text entry 2
Excel formula, sum the value cell and if empty cell left blank 0
Last Modified By in a cell by user 3
Vlookup query 5
Count between two dates using sumproduct 6
Problem with Values greater than a quardrillion(1,000,000,000,000, 1

Back
Top