Excell - help!

  Currantbun 11:14 17 May 2008
Locked

Hey Guys!!

I use excel - a lot! For work related purchases i use order numbers. Eg,

PC0001
PC0002
PC0003
......
PC8999

These are all down the same column. Obviously i don't want to type everyone of these out, is there any quick way of doing this??

  VoG II 11:43 17 May 2008

Type in

PC0001

and press Enter. Now click in that cell and hover the cursor over the bottom right of the cell until the cursor turns into a +

Hold down the left mouse button and drag down as many rows as needed, then release the mouse button.

  Taff™ 12:14 17 May 2008

If you already have numbers set up I find that if you highlight the last 2 numbers and do as VoG suggests Excel continues the numbers sequentually.

  Currantbun 23:56 20 May 2008

Cheers guys!

Between the 2 of you i got it sorted.You've no idea how much easier you've made my work life....

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

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

Adobe shows still-in-development tools, including automatically colourising black-and-white photos

iPhone X news: Release date, price, new features & specs

Comment transformer un iPhone en borne Wi-Fi ?