excel grid sequential numbering

Hi, welcome to the forum

Assuming you want the grid to start in A1 (row 1 would contain headers), you could probably do this with a simple A3=a2+1 copied down and across as needed.
Then B2, C2 etc would be =max(A:A) etc

Please try

=COLUMN(A1)+(ROW(A1)-1)*3

Drag across and down, Change No. in red to match column #

Bo, hopefully 1 of understood what the OP wanted lol.

I took it to mean that the 3x3 table was just an example, and that the grid could be far larger...

but i want to do a whole grid as there is up 1000 numbers in some of the grids

You took it to just be a 3x3 grid. I guess we will find out soon which 1 read the requirement correctly lol

@ mic, this just goes to show that a clear definition/explanation of the problem and requirement is essential for a good response

Ford, LoL, some time mind reading game is fun.

Another guess is
=ROW(A1)+(COLUMN(A1)-1)*3

Indeed, Bo, indeed.

My wife went on an excel course (company paid, so why not?), and they had a very brief into to macros. She started dabbling, got stuck and asked me for help. When asked what she was doing, she told me the main parts of what she was doing, then went on about opening an email and "clicking on some buttons". I asked, which buttons", but she just said "some at the top somewhere" LOL

LoL, something somewhere, someone helps me.

thanks for the answer =ROW(A1)+(COLUMN(A1)-1)*3 this works but the only problem is every column starts at the top of the grid. i want the first row to go down,
the second to go up, the third to go down,ect (in zig-zig pattern)
i need this for many grids of different sizes and some are quite large (example about 80 x 35)
thanks
mic

Please try this and change no. of Row in RED, drag across and down

=IF(ROW(A1)>5,"",ROW(A1)*SIGN(MOD(COLUMN(A1),2)-0.5)+MOD(COLUMN(A1)-1,2)+(COLUMN(A1)-1+MOD(COLUMN(A1)-1,2))*5)

mic, Im happy you got what you wanted, but as you can tell, your request was pretty vague.

Did you try my suggestion?