Excell - help!

  Currantbun 11:14 17 May 08
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 08

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 08

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 08

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.

Nintendo Switch review: Hands on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Here's what should be coming to Adobe Project Felix in 2017

Apple AirPods review: Apple's beautiful new Bluetooth headphones bring true intelligence to…