Create columns for each entry

The other issue I have is that when you add student 2 info, student 3,..etc the spread sheet would have the data in new column while I want all the data under same columns so I could easily after that sort it for example by grade and print it out. Is there a way to make multiple entries go in same spread sheet under same columns? 

Unfortunately it is not possible to make multiple entries go in the same column. Each data will have to be in a new column. Perhaps you can try one of our widgets such as the Configurable Widget or Matrix Dynamique to have the student in the same column when checked in the submissions page.