Siamese method

 

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

 

 

5x5 symmetric magic square

17 24 1 8 15
23 5 7 14 16
4 6 13 20 22
10 12 19 21 3
11 18 25 2 9

 

 

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

 

Download
5x5, Siamese method.xls
Microsoft Excel werkblad 8.7 KB