Use the keyboard shortcut Alt+123 (Option+Shift+8 on Mac) to insert curly brackets { } in Google Sheets. These symbols appear directly in cells and can be used in formulas, text formatting, or data labeling.
Brackets in Google Sheets serve as visual or functional markers. They're not part of the formula language like parentheses, but they improve readability in text-based entries. For example, you might use them to group related items in a list: "{Task A, Task B, Task C}".
Unlike parentheses, which control calculation order in formulas, brackets don't alter logic. They're purely decorative or organizational unless used in specific functions like ARRAYFORMULA or within string concatenation.
When you type { or }, Google Sheets treats them as regular characters. They display exactly as typed and do not trigger any function unless embedded in a formula string.
To insert a bracket, press Alt+123 on Windows or Option+Shift+8 on Mac while the cursor is in a cell. This inserts a pair of curly braces: { }. The shortcut works in any mode-editing, viewing, or selecting cells.
If your keyboard lacks a numeric keypad, use the on-screen keyboard or enable the Unicode input method. On Chrome OS, press Ctrl+Shift+U, then type 007B for { and 007D for }.
Google Sheets supports several bracket types, though only curly braces { } are easily inserted via standard shortcuts. Square brackets [ ] and parentheses ( ) are available through typing or special character insertion.
| Bracket Type | Insert Method | Common Use Cases |
|---|---|---|
| { } | Alt+123 (Win), Option+Shift+8 (Mac) | Grouping lists, marking optional items, formatting headers |
| [ ] | Type directly or use Insert > Special Characters | Denoting optional parameters, marking placeholders |
| ( ) | Standard keyboard keys | Mathematical expressions, formula grouping |
Curly brackets are most useful when you want to visually separate a set of values without altering their meaning. For example, in a project timeline, you might label a phase as "Phase 3: {Design, Prototyping, Testing}" to show it's a single unit.
A common mistake is assuming brackets affect formula execution. They do not. If you write =SUM(A1:A5) and accidentally type {A1:A5}, the formula fails because Google Sheets interprets { as text, not a range.
In a budget tracker, you might use brackets to denote recurring expenses: "{Monthly Rent, Utilities, Internet}". This makes the structure clearer at a glance, especially when scanning multiple rows.
For a team task list, enter: "{Review Draft, Finalize Design, Submit Report}" in a single cell. This groups actions under one milestone, improving readability compared to listing them with commas.
When preparing a report for stakeholders, use brackets to show assumptions: "Estimated delivery time: 6 weeks {based on current staffing levels}." This separates facts from context without cluttering the main data.
I once used curly brackets in a sales forecast sheet to group product categories. Instead of writing "Product A, Product B, Product C", I wrote "{Product A, Product B, Product C}" to make the list stand out during presentations. The visual cue helped viewers parse the data faster.
Some users think brackets can replace parentheses in formulas. They cannot. Parentheses are required for mathematical precedence and nested functions. Brackets have no role in expression evaluation.
Another error is using brackets to create arrays. While ARRAYFORMULA accepts ranges, it doesn't recognize { } as delimiters. To define a horizontal range, use commas inside the function: ARRAYFORMULA({A1:A5,B1:B5}). The braces here are part of the syntax, not text.
Brackets also don't support conditional formatting. You can't apply rules based on whether a cell contains { or }. Formatting depends on cell content, not symbol presence.
Contrary to belief, Google Sheets does not auto-format brackets into bold or color. They remain plain text unless manually styled.
If you frequently need brackets, consider creating a custom keyboard shortcut using Google Apps Script. This allows you to assign a key combo like Ctrl+Shift+B to insert { } automatically.
For consistent formatting across a sheet, use Find and Replace. Search for "{" and replace with "{" to ensure uniformity. This is useful when cleaning imported data.
You can also embed brackets in formulas using the CHAR() function. For example, =CHAR(123)&"Data"&CHAR(125) returns {Data}. This method is useful when building changing strings in reports.
When sharing sheets, be aware that some devices or apps may render brackets incorrectly. Test exported versions in Excel or PDF to confirm appearance.
When moving data between tools, remember that brackets may not transfer correctly in CSV exports. Always verify output in a text editor or import test.
Understanding how to make a bracket in Google Sheets ensures accurate, readable data presentation. Use curly braces for grouping, not computation. They improve clarity in lists, headers, and assumptions-but never for formula logic.
Mastering this small detail enhances professionalism in spreadsheets, especially when collaborating or presenting data. Practice inserting brackets using the shortcut to build muscle memory.