How to Create a Scoreboard in Excel

By Vera Leigh

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.

Step 1

Open a new Microsoft Excel worksheet.

Step 2

Click on cell A2. Type "Team 1." Click on cell A3. Type Team "2."

Step 3

Enter the inning numbers 1-9 in cells B1 thru J1.

Step 4

Enter the corresponding scores for each team in each inning in the cells provided. (B2 and B3 thru J2 and J3).

References & Resources