*~*TGIF! Daily Chat*~*

bookseller1980

Thank you so much Inky! I am so excited - I've learnt something new. :j
(there were 150 to do).

Ellidee

^^^^ Can we go back to talking in English please ?

InkyCats20

redsquirrel80 wrote: »

The way Inky says works, although you might have to click on the little box that appears to the right (auto fill options) and select 'fill series' to get a sequence of numbers.

The other way is to type =ROW(A1) in the first box and then drag the cross down to the bottom of your list and that will number them all in sequence.

Ooo thanks Red, haven't used =ROW(A1), things you pick up on the MSE daily chat thread :rotfl:

InkyCats20

Sorry Ellidee - I go back to lurking for the rest of the day

redsquirrel80

InkyCats20 wrote: »

Ooo thanks Red, haven't used =ROW(A1), things you pick up on the MSE daily chat thread :rotfl:

Don't you just love all those little formula thingies

My favourite thing at the moment is data validation to make drop down lists.. ooh and pivot tables.. drool.. :rotfl:

jinky67

Jinky like learning

She just learned something very exciting

whatatwit

I know Jinky.....you are going to be the next Carol Vorderman

Ellidee

InkyCats20 wrote: »

Sorry Ellidee - I go back to lurking for the rest of the day

Oh no please don't ! I was only joshing - am a serial lurker meself

redsquirrel80

jinky67 wrote: »

Jinky like learning

She just learned something very exciting

Are you learning Excel?

InkyCats20

Ooo Jinky's back & I thought she'd got Bookie to post a question to put everyone off her "learning" experience

Red - Yes I do like the all the formula thingies, former colleagues always used to roll their eyes at me, (much like Ellidee is probably doing now) :rotfl: