How to Create a Scoreboard in Excel
If you kept track of the winning baseball game, you can record the scores for each of the innings in a Microsoft Excel spreadsheet. Excel provides columns and cells for storing the data. You can use this spreadsheet to keep track of games you are watching at home.
Open a new Microsoft Excel worksheet.
Click on cell A2. Type "Team 1." Click on cell A3. Type Team "2."
Enter the inning numbers 1-9 in cells B1 thru J1.
Enter the corresponding scores for each team in each inning in the cells provided. (B2 and B3 thru J2 and J3).