Smartsheet Keyboard Shortcuts
Smartsheet leans more heavily into actual spreadsheet conventions than most project management tools, since its core grid view behaves much closer to Excel than to a typical kanban or list-based task tool like Trello or Asana — cell navigation, fill-down, and row insertion shortcuts will feel immediately familiar to spreadsheet users in a way that a card-and-board interface simply wouldn't. This overlap is deliberate, aimed at easing the transition for teams migrating off spreadsheet-based project tracking, and it means anyone who already knows Excel's Ctrl+D fill-down or Shift+Space row-selection habits arrives at Smartsheet's grid already knowing a meaningful chunk of what they need, distinct from the Excel-specific formula-auditing and pivot-table depth that Smartsheet deliberately doesn't try to replicate. Because Smartsheet runs in a browser tab for most users, a few of its grid shortcuts can get intercepted by the browser itself unless you're using the dedicated desktop app. Automated workflows, which trigger notifications or approval requests based on conditions like a due date approaching or a status column changing, live entirely in a separate visual rule-builder panel with no keyboard-shortcut equivalent at all — picking a trigger column, a comparison operator, and a recipient list is point-and-click work by design, not something a key combo could meaningfully shortcut. The Gantt view, generated automatically from the same underlying grid data (specifically start/end dates and the row hierarchy built through indenting), shares almost none of its shortcut vocabulary with the grid view itself, since dragging a bar to adjust a task's timeline is a fundamentally different interaction than typing into a spreadsheet cell. Column freezing and scoped row-update requests both address real friction that shows up specifically once a sheet grows wide and involves people beyond the core project team — keeping the task-name column visible while scrolling through many data columns, and collecting an update from an external stakeholder without exposing the whole sheet to them, are the kinds of practical needs that separate Smartsheet's project-tracking use case from a plain spreadsheet like Excel or Google Sheets.
Grid Navigation
| Action | Windows | Mac | Description |
|---|---|---|---|
| Move between cells | Arrow keys | Arrow keys | Moves the active cell selection in the corresponding direction across the grid, identical to standard spreadsheet navigation. |
| Move to next cell | Tab | Tab | Confirms the current cell's entry and moves selection one column to the right, the standard spreadsheet data-entry navigation pattern. |
| Select entire row | Shift+Space | Shift+Space | Selects every cell in the current row, matching Excel's identical binding for the same action, useful before applying a row-level action like indenting or formatting. |
| Switch to Gantt view | View menu > Gantt | — | Switches the current sheet's display from the standard grid to a Gantt chart generated automatically from start/end date columns and the row hierarchy built through indenting. |
| Freeze a column | Right-click column header > Freeze | — | Locks a column (commonly the primary task-name column) in place while scrolling horizontally through a wide sheet, keeping it visible regardless of how many columns are scrolled past. |
| Jump to a specific row | Ctrl+G (varies by version) | — | Opens a Go To prompt for jumping directly to a specific row number, useful on a sheet with hundreds or thousands of rows where scrolling manually to a known row number would be slow. |
Row Management
| Action | Windows | Mac | Description |
|---|---|---|---|
| Insert row above/below | Ctrl+Shift+Plus (varies) or right-click | Cmd+Shift+Plus | Inserts a new blank row adjacent to the current selection, pushing existing rows down (or up, depending on the option chosen) to make space. |
| Delete selected row(s) | Ctrl+Minus (varies) or right-click | Cmd+Minus | Removes the selected row(s) entirely from the sheet, shifting subsequent rows up to close the gap. |
| Indent row (create subtask) | Tab (with row selected, not in cell edit) | Tab | Indents the selected row to become a child/subtask of the row above it, building Smartsheet's hierarchical task structure used for outline-style project breakdowns and automatic Gantt chart parent/child relationships. |
| Outdent row (promote level) | Shift+Tab (with row selected) | Shift+Tab | Bumps the selected row up a level in the sheet's outline structure, the exact reverse of what indenting it would do. |
| Attach a file to a row | Row menu > Attach File | — | Attaches a document, image, or other file directly to a specific row, useful for keeping supporting materials tied to the exact task or line item they relate to. |
| Send a row update request | Row menu > Request Update | — | Sends a request to a specific person to fill in or confirm data on a particular row, without granting them full access to edit the rest of the sheet, useful for collecting status updates from people outside the core project team. |
Formulas Editing
| Action | Windows | Mac | Description |
|---|---|---|---|
| Fill down | Ctrl+D | Cmd+D | Grabs whatever's in the first row of a selected range — a value or formula — and copies it down through every other row in that selection, mirroring Excel's own fill-down behavior. |
| Undo | Ctrl+Z | Cmd+Z | Reverts the most recent change to the sheet, covering both cell value edits and structural changes like row insertion or deletion. |
| Edit cell formula | F2 or double-click cell | F2 or double-click | Enters edit mode on the selected cell, showing its underlying formula (if any) for direct editing rather than overwriting the displayed value. |
| Copy and paste cell values | Ctrl+C / Ctrl+V | Cmd+C / Cmd+V | Copies and pastes cell content, functioning identically to standard spreadsheet copy-paste behavior, including pasting across multiple cells when a range is selected. |
| Create an automated workflow rule | Automation > New Rule | — | Opens the visual rule-builder for setting up automated actions (like a notification or approval request) triggered by a condition such as a status change or approaching due date. |
Frequently Asked Questions
Why does indenting a row matter beyond visual organization?
Indenting in Smartsheet doesn't just nest a row visually — it establishes a real parent-child relationship used by features like automatic Gantt chart date roll-ups (a parent task's duration can automatically reflect its children's date ranges) and hierarchical reporting, making the indent/outdent shortcuts more functionally significant than simple list nesting in a plain document.
Do Smartsheet formulas use the same syntax as Excel?
Smartsheet's formula language is deliberately similar to Excel's for common functions (SUM, IF, VLOOKUP-equivalents), easing the learning curve for spreadsheet-experienced users, though it includes its own project-management-specific functions (like referencing parent/child row relationships) that have no direct Excel equivalent.
Why does Tab sometimes indent a row instead of moving to the next cell?
Tab's behavior depends on context — if you're actively editing text inside a cell, it moves to the next cell as expected. If a whole row is selected (not in cell-edit mode) when you press Tab, Smartsheet instead interprets it as the indent command, since row-level selection and cell-content editing are treated as distinct interaction states.
Does the Gantt view use the same keyboard shortcuts as the grid view?
Almost none of them carry over — the Gantt view is generated from the same underlying start/end date data and row hierarchy, but interacting with it (dragging a bar to shift a task's timeline, for instance) is a fundamentally different, mouse-driven interaction than typing values into spreadsheet cells, so the grid's navigation and editing shortcuts largely don't apply there.
Can automated workflow rules be triggered by more than just a due date?
Yes — the rule-builder supports a range of trigger conditions including specific column value changes (like a status moving to 'Complete'), row additions, and date-based triggers, each paired with an action such as sending a notification, requesting approval, or updating another field automatically.
How does Smartsheet's grid compare to Excel's for someone deciding between the two?
The everyday cell-navigation and editing shortcuts covered here transfer almost directly from Excel, but the similarity stops at Excel's deeper analytical territory — pivot tables, Excel's dense formula-auditing tools like Trace Precedents, and its huge library of built-in functions all go well beyond what Smartsheet's grid is built for. Smartsheet trades that analytical depth for built-in project-management structure (hierarchy, Gantt charts, automated workflows) that Excel has no native equivalent for at all without a heavily customized template.
Are file attachments visible to everyone who can view the sheet, or just the person who uploaded them?
Attachments are generally visible to anyone with appropriate sharing permission on that sheet, consistent with the rest of the row's data, rather than being restricted only to the uploader by default — sharing and permission settings for the whole sheet govern attachment visibility rather than a separate attachment-specific permission layer.