Take a look at this link, it explains it all

http://www.cpearson.com/excel/relative.htm