What is Cricket World Cup?Ĭricket world cup is a game which is played by 14 countries over a span of roughly two weeks. The origin of cricket cannot be specified till date, however it can be agreed upon that cricket originated somewhere in the united kingdom in the 18th century and became the national sports of the country by 1877. You May also See Tennis Score Sheet Templates Where Did Cricket Originate? The latest form of modern cricket is known as Twenty -20, which is a improvised version of one – day cricket, albeit on a much smaller scale, spanning only for a period of 3-4 hours. The second one is known as one day cricket, where the match continues only for a day. The first one is known as test cricket which is played by two teams spanning over a period of 5 days. The game of cricket has three variations. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.Download How Many Types Of Cricket Is Played? Follow the ExcelDemy website for more articles like this. Let us know if you have more ways to do the task. Thus, you will be able to show how to make a cricket scorecard in excel. Henceforth, follow the above-described methods. You can easily change the color of the scorecard according to your wish.

You can create the scorecard, but you have to input the data manually.If you want to create the whole game summary, you have to do the same step for the 2nd innings also. We have shown the scorecard for an innings of the game.Read More: How to Calculate T Score in Excel (4 Easy Ways)

Finally, you will get the desired result.Furthermore, input the two highest run-getters in the left-side column and the two highest wicket-takers in the right-side column.In addition, we input the data manually in this format( Total Runs/ Total Wickets).

In the dataset, we have the Final Score in Column B.

To begin with, you have to create a dataset.

We can do it by following the below steps. In this last step, we have to show the summary of the game of an innings. Read More: How to Create a Scoring System in Excel (With Easy Steps)

Last, you will get the desired bowling scorecard.

Next, use the Fill Handle option to apply it to all desired cells.

Fourth, you will get the result after pressing the Enter button.

Cricket scoring sheet pdf