Can anyone help me as i have never used excel before

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

Guest

I am new to windows excel and i am typing in column 'A' the following;

08 001
08 002
08 003
Now, rather than type this out 958 times downwards, is there a way of
getting it to fill automatically rather than typing it in please ?

I tried clicking the bottom left hand corner and scrolling down but all i
got was this;

08 001
09 001
10 001
and so on.

Can anyone tell me how to make it automatically put the next number in
please ?
Mind you, thats if it can be done ? Bearing in mind i am not computer
literate so please, no quantum physic type answers or my brain cell will
explode !

Thank you all for looking
 
try typing in "08 001 in the first cell, fill down using the fill handle on
the bottom right of the cell and fill series. Then use find & replace an
replace " leaving the replace cell blank and select replace all.

or

format the cell to the custom format "08" 000. put 1 in the first cell and
fill down then select fill series
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
Hi John,
Thank you for replying.

Please forgive me here ok, bear with me.

1.What is a cell ?

2.Do i put " before i type 08 001 as you have put ?

3.How do i format please ?

as you can see, i am new to this.

Thank you for your help sir
 
John,

sorry, i am dancing around the room now.

ok, i did "08 001 and it worked.

Now all i have to do is work out how to get rid of " ?

Thank you mate.
made my day this has :-)
 
Oh wow,

Ok, a very quick update john.

You sir are brilliant ! A super star.

Thank you

You will not belive how much time you have saved me sir.

I got the find and replace and it worked.

Thank you once again.

If you lived here the UK i would buy you a pint !

Kindest regards

andy
 
I suggest you purchase Microsoft Office Excel 2007 (or whatever version you
have) Step by Step. By Curtis D. Frye. Published by Microsoft. $24.99 U.S.
Then follow that with Microsoft Office Excel 2007 (or whatever version you
have) Bible. By John Walkenbach. Published by Wiley Publishing Inc. $39.99
U.S.
 
Wondering said:
I suggest you purchase Microsoft Office Excel 2007 (or whatever version you
have) Step by Step. By Curtis D. Frye. Published by Microsoft. $24.99 U.S.
Then follow that with Microsoft Office Excel 2007 (or whatever version you
have) Bible. By John Walkenbach. Published by Wiley Publishing Inc. $39.99
U.S.
Click to expand...
What? Spend money! You must be daft!
 
Thanks for the feedback, I am glad it worked.

I do live in the UK so how about that pint then? - The Ice hockey team I
support should give you an indication of where I live

--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
Back
Top