Have a look in the help index for
ABSOLUTE

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Deltic" wrote in message
...
I need to design a sheet that has along the top 1 - 50 (number of
questions in the paper) and down the side has 1 - 50 (number of
questions answered correctly). Is there a way of filling in the graph
without going to each cell and entering the formula one at a time, for
instance the first cell would be B1/A2*100 and so on. I have tried but
cannot get the correct formula to use, can you help?