Siamese method

 

Put digit 1 in the middle of the top row. Put the digits 2 up to n (= length of the square) each time one cell diagonal up and to the right. Put digit n+1 below digit n. Put the digits n+2 up to 2n each time one cell diagonal up and to the right. Put digit 2n+1 below digit 2n. Etcetera ...

 

 

9x9 symmetric magic square

47 58 69 80 1 12 23 34 45
57 68 79 9 11 22 33 44 46
67 78 8 10 21 32 43 54 56
77 7 18 20 31 42 53 55 66
6 17 19 30 41 52 63 65 76
16 27 29 40 51 62 64 75 5
26 28 39 50 61 72 74 4 15
36 38 49 60 71 73 3 14 25
37 48 59 70 81 2 13 24 35

 

 

You can use this method to construct magic squares of odd order from 3x3 to infinite and you get a symmetric (but not pan)magic square.

 

 

Download
9x9, Siamese method.xls
Microsoft Excel werkblad 9.0 KB