Function Problems

Create a Dynamic Card-Game Scoresheet in Excel

Ayan MasoodAyan Masood Nov 22, 2026 868 views

Question details

The user wants a card-game scoresheet that accepts a player count and names while displaying only the player columns needed.

Create a Dynamic Card-Game Scoresheet in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Set up the inputs

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.

2
Create player headings

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.

3
Add rounds and totals

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.

4
Mark unused columns

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.

5
Hide columns if desired

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.

Build a Scoresheet with a Player Count and Formulas
Adjust the scoring rules: The total formula simply adds round scores. Replace it with calculations appropriate to your card game if bonuses, penalties, or other rules apply.
Create your scoresheet in WPS

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. 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. 2. Add dynamic headings: In B4, enter =IF(COLUMN()-1<=$B$1,B2,"") and drag the fill handle across to E4.
  3. 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. 4. Hide unused columns: Select unused column headers, right-click, and choose Hide. Use Unhide to restore them when the player count increases.
Use formulas to update player headings and score totals.Open and save Microsoft Excel XLSX workbooks.Work with a familiar spreadsheet interface.Use WPS Office for free.
microsoft office alternative - wps office

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.