![]() I prefer to do 4-quarter payouts so if you have a different payout, you can change that. I’m not going to give step by step instructions on these but they’ll be included in the final download. We have some space on the side so let’s add the price, pot, and payouts. You can use my Football Squares random number generator to shuffle the numbers for you quick and easy.īefore I give you the link to download this spreadsheet, there’s a few more things I like to add. After all squares have been filled, that’s when you’ll want to add the numbers 0 through 9 for both teams in random order. You can then print off your Excel sheet, or email it around to have each participant enter their name into the squares they want. Before selling any squares, make sure to clear out the numbers. That’s it, you just made a basic Football Squares pool that looks great. Go to the alignment tab and click on the checkbox for Wrap text. Then, select all the name boxes, right-click and click on Format Cells. Update the name cells to wrap text.Įnter a name into one of the squares so you can see how it’ll look. Simply select those cells and change the background color to a light gray. You don’t have to do this but it looks better. ![]() Set the horizontal and vertical alignment to be “Center”. Select your grid, right-click and select Format Cells again. This will look better for the numbers and for the names that get entered into the “squares”. I like to also choose the thick border to go around the outside of the entire football grid. Click on the borders icon in the toolbar and select borders for every side (All Borders). Select all the table cells that correspond to the numbers and where the names will go. Next, change the orientation from 0 degrees to 90 degrees. Here, change the vertical alignment from Bottom to “Center”. Right-click on the cell and select Format Cells. To do this, highlight the respective cells and then click on the Merge & Center button at the top.Īfter you do all three headings, it will look like this: Change the text orientation for the Away Team.įor the team name on the left, we need to update the text to read sideways. Update the column and row widths.įor both the main title and the team names, merge the cells for their areas. In my example below, I went with size 36 for the main title, size 24 for my team names, and 16 for the numbers. In general, you’ll want to make the title the largest, the team names next largest and then the numbers. For me, I’m keeping with the default Calibri since it’s super readable and looks fine. Each font will have its own size and spacing so it’s better to pick your font before you adjust your text sizes. Update font and adjust text sizes.īefore you go to much further, change your font if you’re going to. We’re adding the numbers 1 through 0 now in order but later, you can change them. Then, type in the titles and numbers.įor now we’re just adding the titles and leaving room between for spacing. First, create a new blank worksheet in Excel. You can find a link to download it at the bottom. So before we get into the steps, here’s a screenshot of what we’re building. Full Instructions For Creating Football Squares in Excel Note: the instructions here are for Excel but the process would be similar for Google Docs, OpenOffice, or other spreadsheet solutions. I like to use Excel’s built-in formatting and structure as much as possible to save time but still end up with a great football grid that you can use again and again. There’s the basic instructions and you’ll find the full instructions below.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |