insert a formatted row in excel [office for xp 2002]
 

I have a inventory list, in which serveral columns are using validation
[Catergory, item,description, room,] in order to make the list more
efficient, I would like automatically add a row with the same validations,
once you press the enter key at the last column[RECEIPT].
example below:

QTY CATERGORY ITEM DESCRIPTION ROOM AGE 100% RECEIPT