Excel query

  Daisy22 14:29 04 Dec 2006
Locked

I've used excel a lot in the past, but now I want to do something and can't for the life of me remember how to do it.

In column A I want to enter a list of numbers from 1 to 900 odd, is there an easy way of automatically using excel to number the rows as in
1
2
3 etc. etc.

It's probably very simple, but I just can't fathom it out.
Many thanks

  GroupFC 14:36 04 Dec 2006

Yes enter 1 and 2 in the first 2 cells. Hihlight the cells and then the cursor to the bottom right corner and turns into a black cross. Now right click and drag down the columns.

Robert's your mother's brother!

  GroupFC 14:38 04 Dec 2006

I was typing too fast to beat VoG™ and look what happens! Hopefully you get the idea!

  VoG II 14:42 04 Dec 2006

Left click and drag down the column.

  GroupFC 14:51 04 Dec 2006

I always did mix up my left and right!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

Photoshop CC 2018 released with new Curvature Pen and better brush tools

Camera tips to take better iPhone photos

Les meilleures applications de covoiturage 2017