Indent pushes cell content to the right, away from the left edge. It’s how you visually nest a sub-item under a parent row, or pull a subtotal in from its category label.
You’ll reach for it when a column has hierarchy. Things like a budget with categories and line items, or a checklist with main tasks and sub-tasks underneath.
There is no built-in keyboard shortcut for indent on Windows or Mac. The fastest route is the Increase indent and Decrease indent toolbar buttons, which take one click each.
Is There a Keyboard Shortcut for Indent in Google Sheets?
Indent Keyboard Shortcut (
Windows)
No native keyboard shortcut on Windows. Use the toolbar Indent buttons below.
Indent Keyboard Shortcut ( Mac)
No native keyboard shortcut on Mac. Use the toolbar Indent buttons below.
Neither Windows nor Mac has a key combo for this. Google Sheets added real Increase indent and Decrease indent toolbar buttons in 2022, and those are the quickest way to do it. Indent is a cell-level format property. It shifts content visually to the right without changing the cell’s actual value.
How to Indent in Google Sheets (Step by Step)
- Select the cell or range you want to indent.
- Look at the toolbar, near the horizontal alignment buttons. You’ll see two icons that look like lines with an arrow pointing right (Increase indent) and one pointing left (Decrease indent).
- Click Increase indent to push the content right. Click again to push it further.
- To pull content back toward the left edge, click Decrease indent.
- Indent stays with the cell even after you copy, sort, or filter the data.
Here’s a quick example. You have a column of expenses. The category rows read “Marketing” and “Operations.” Under each, you have line items like “Ads,” “Events,” and “Software.”
Select the line-item rows and click Increase indent once. Now the line items sit visibly under their categories without changing any text. The sheet reads as a small outline.
Another Way to Indent
Format menu path
If you can’t see the toolbar buttons, the same options are in the menu.
- Select the cell or range.
- Click Format → Alignment → Increase indent (or Decrease indent).
That’s the same action as the toolbar click. Use whichever path is closer to your cursor.
Leading-space workaround
Before the indent buttons existed, the common trick was prefixing the cell with a space, or using a non-breaking space from =CHAR(160) so the leading character didn’t get stripped.
This still works if you need to control the indent amount precisely, or if you’re writing into a cell that won’t accept format changes for some reason.
The trade-off is that the spaces become part of the cell’s value. Lookups, comparisons, and LEN() all count them, which can throw off formulas that match on exact text.
Things to Watch For
- Indent is a format, not text. It doesn’t change the cell’s value, so
=A2will return the original text without the indent. - Export keeps it. Indent carries through cleanly to PDF exports and to
.xlsxdownloads. Excel reads the same property, so the file opens with the indent intact. - Conditional formatting doesn’t see indent. You can’t write a rule like “highlight indented rows” because the indent isn’t part of the cell’s value or any addressable property.
- Mobile app support is limited. The toolbar buttons live in the desktop interface. On the Android and iOS apps you may need to use the menu path or rely on the desktop site.
- One indent step at a time. There’s no “indent by 4” input. You click the button once per step.
Google Sheets keyboard shortcuts
Related Google Sheets shortcuts: