I'm trying to create a spreadsheet with squares down the side with the rest of the numbers filling in, as below:

1

2 3

4 5 6 7 8

9 10 11 12 13 14 15

16 17 18 19 20 21 22 23 24.....etc up to a big number

As a beginner I'm having zero success here, so any help with this would be appreciated...

for an encore I then want to format the cells that contain prime numbers. I have some code here that I think will work if I get the above to work.

cheers for any help with this

Kevin