Create a Dynamic Card-Game Scoresheet in Excel
Question details
The user wants a card-game scoresheet that accepts a player count and names while displaying only the player columns needed.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Create a reusable scoresheet for a card game with a variable number of players.
- Observed behavior
- The desired scoresheet should display the relevant players and calculate scores according to the game's rules.
Decide how many players the sheet should support, how many rounds to track, and whether scores are added or calculated using special rules. The example below supports up to four players and adds scores across ten rounds.
Build a Scoresheet with a Player Count and Formulas
Use formulas to display headings and totals for the selected players, then hide unused columns manually if needed.
The formulas leave unused headings and totals blank, but they do not hide worksheet columns. Conditional formatting can visually distinguish unused columns; it cannot hide them.
In a new Excel worksheet, enter the number of players from 1 to 4 in B1. Enter player names in B2:E2, one name per cell.
Enter =IF(COLUMN()-1<=$B$1,B2,"") in B4, then drag the fill handle across to E4. Only headings within the player count will display.
Enter round labels in A5:A14 and type scores in B5:E14. In B15, enter =IF(COLUMN()-1<=$B$1,SUM(B5:B14),"") and fill it across to E15.
Select B4:E15, then choose Home > Conditional Formatting > New Rule. Choose the option to use a formula, enter =COLUMN()-1>$B$1, and select a gray fill.
Select the worksheet column headers for unused players, right-click, and choose Hide. To show them again, select the columns on either side, right-click, and choose Unhide.

Adapt an Excel Scorecard Template
Start with a template if you prefer to modify an existing layout instead of building one from scratch.
Build a Card-Game Scoresheet in WPS Spreadsheet
Use WPS Spreadsheet to enter player names, display headings based on a player count, and calculate round totals. Hide unused columns manually when you want a cleaner view.
- 1. Create the inputs: Open WPS Spreadsheet and create a blank workbook. Enter a player count from 1 to 4 in B1 and the player names in B2:E2.
- 2. Add dynamic headings: In B4, enter =IF(COLUMN()-1<=$B$1,B2,"") and drag the fill handle across to E4.
- 3. Track rounds and totals: Enter round labels in A5:A14 and scores in B5:E14. Enter =IF(COLUMN()-1<=$B$1,SUM(B5:B14),"") in B15 and fill it across to E15.
- 4. Hide unused columns: Select unused column headers, right-click, and choose Hide. Use Unhide to restore them when the player count increases.

Frequently Asked Questions
Can Excel automatically hide unused columns with a formula?
No. A formula can return a blank value, but it cannot hide a worksheet column. Select unused column headers, right-click, and choose Hide, or use a macro if automatic column hiding is required.
How do I change the number of players?
In the example scoresheet, change the value in B1 to a number from 1 to 4. The player headings and totals update; manually unhide or hide columns as needed.
Will reducing the player count delete existing scores?
No. The formulas blank the unused headings and totals, but scores entered in B5:E14 remain in the worksheet. Clear unwanted scores manually by selecting the cells and pressing Delete.
How can I add bonuses or penalties?
Add cells for bonuses or penalties and adjust each player's total formula. For example, add a bonus cell to the SUM calculation or subtract a penalty cell according to the game's rules.




