How Do You Create a Tally Sheet in Excel?

Create a tally sheet in Excel by creating a new spreadsheet with two columns. Write a category in each of the left hand column's rows; for example, if you asked people what their favorite TV show is, the left column would contain the names of the different shows that people told you. The right-hand column contains each category's frequency; if 20 people said they like "Game of Thrones," enter "20" next to the "Game of Thrones" row.