Today’s spreadsheet will allow users to create 36 flash cards on one page with two-sided printing. We first tackled the idea of spreadsheet flash cards with this post on virtual flash cards, and today’s spreadsheet will tackle physical, printable cards.
We’ll have a separate sheet for our questions, which will feed into a sheet with our flash cards:
Then we’ll make our flash cards. First, we hit the print function, in order to show the dotted page lines. Then we sized the cards into a 9×4 grid, merging and centering cells, and adjusting the box widths to fill in the page lines. Finally, we linked the cards to the question and answer cells from the ‘questions’ tab. This was a little tricky as when you print two-sided the answers need to be flipped across the middle in order for them to match up with the questions:
That’s pretty much it – download the spreadsheet and try it out for yourself! Flash Card Spreadsheet in Excel
To print the flash cards, you’ll have to use the print option: Print on Both Sides –> flip pages on long edge.
We added some ideas for various flashcards:
- Single digit numbers that sum to double digits
- US States, State Capitals, Population
- African/European States/Capitals