Go to the View tab and uncheck Gridlines . This makes your border-based bracket pop against a clean white background.
Start by narrowing your column widths. Highlight columns A through Z, right-click the header, select Column Width , and set it to 5 . This gives you a "graph paper" feel that is much easier to work with. Step 2: Building the First Round
: Once your team names and formulas are set, go to the Review tab and select Protect Sheet . Allow users to edit only the score cells. This prevents anyone from accidentally deleting your formulas or changing team placements. make a bracket in excel
Choose the layout (this layout naturally mimics a left-to-right tournament bracket) and click OK .
Select cells and apply Outside Borders to create the connector lines leading to the Semifinals. Go to the View tab and uncheck Gridlines
=IF(C2>C3, B2, IF(C3>C2, B3, "Tie/Overtime"))
If you want brackets to appear in a cell as characters: Highlight columns A through Z, right-click the header,
Explanation: If B1 contains 1, show team from A2; if 2, show team from A3; otherwise show “TBD”.