To save time, use following keyboard shortcut keys in Smartsheet.
NOTE: Mac users should use Command ⌘ instead of Ctrl.
Cut, Copy, Paste and Other Frequently Used Shortcuts
| PC Shortcut | Mac Shortcut | Description |
|---|---|---|
| Ctrl + X | Command + X | Cut |
| Ctrl + C | Command + C | Copy You can copy data within a sheet in Smartsheet or between sheets. You can copy rows, cells, formulas, hyperlinks, and hierarchy. NOTE: Copying a row does not copy its associated attachments or comments. |
| Ctrl + V | Command + V | Paste TIP: If you've copied a multi-line cell in Excel or other program, double-click on the cell in Smartsheet before pasting it in to prevent the lines from spilling over into the cells below. |
| Ctrl + S | Command + S | Saves all unsaved information |
| F2 | Fn + F2 | Enters edit mode on selected cell |
| Ctrl + Z | Command + Z | Undo the previous action since last save |
| Ctrl + Y | Command + Y | Redo the previous action since last save |
| Ctrl + D | Command + D | Fill down Useful when a column contains a formula that you want to use in every cell in that column. TIP: This functionality is also available by clicking and dragging from the bottom-right corner of a selected cell. |
Open a Sheet, Find Information, Move Around in a Sheet
| PC Shortcut | Mac Shortcut | Description |
|---|---|---|
| Ctrl + / | Command + / | Open a Sheet |
| Ctrl + F | Command + F | Find information within a sheet |
| Ctrl + G | Command + G | Display the Go To Row window to navigate to a specific row in the sheet |
| Home | Home | Go to the first cell of the current row |
| End | End | Move to the last cell of the current row |
| Ctrl + Home | Command + Home | Takes you to the top left cell of a sheet |
| Ctrl + End | Command + End | Takes you to the bottom right cell of a sheet |
| PgUp | Page Up | Moves you up in a sheet |
| PgDn | Page Down | Moves you down in a sheet |
Work with Hierarchy
| PC Shortcut | Mac Shortcut | Description |
|---|---|---|
| Ctrl + ] (right bracket) | Command + ] (right bracket) | Indent the row (you will see the indent level in the Primary Column only) |
| Ctrl + [ (left bracket) | Command + [ (left bracket) | Outdent the row (you will see the indent level in the Primary Column only) |
Formatting
| PC Shortcut | Mac Shortcut | Description |
|---|---|---|
| Ctrl + Enter | Command + Enter | Inserts a carriage return or line break in Text/Number cells NOTE: In order to see the carriage returns in the sheet, apply wrap formatting to the cell by clicking the Wrap button on the left toolbar. |
| Ctrl + I | Command + I | Italic |
| Ctrl + U | Command + U | Underline |
| Ctrl + B | Command + B | Bold |
| Alt + 0149 | Option + 8 | Inserts a bullet point in the cell |
Insert or Select Rows and Columns
| PC Shortcut | Mac Shortcut | Description |
|---|---|---|
| Insert | Ctrl + I | Inserts a row above the selected row NOTE: To insert multiple rows at once, press Shift and select multiple row headers, then click Insert. |
| Ctrl + Spacebar
| Ctrl + Spacebar | Selects the entire column of your active or selected cells |
| Shift + Spacebar | Shift + Spacebar | Selects the entire row of your active or selected cells |
| Spacebar | Spacebar | Displays or removes a checkbox, star, or flag in the selected cell. For more information about checkbox, star, and flag columns see: Use the Best Column Type for Your Data |
Work with Dates
The following shortcuts work in cells of the Date column type. For more information about column types, see Use the Best Column Type for Your Data.
Note that these abbreviations currently work only for English terms.
| Shortcut (PC & Mac) | Description |
|---|---|
| t | Inserts today's date |
| +n (plus sign and a number) | Enters a date n days from today’s date For example, if today’s date is 12/11/17, pressing +3 will enter 12/14/17. |
| -n (minus sign and a number) | Enters a date n days before today’s date For example, if today’s date is 12/11/17, pressing -3 will enter 12/8/17. |
| sun mon tue wed thurs fri sat | The date corresponding to the day of the week in the current week For example, if today’s date is 12/11/17, typing “sun” will return 12/10/17. |
| yes | Yesterday's date |
| tom | Tomorrow's date |
| last week | The current date -7 days |
| next week | The current date +7 days |
| mmm dd, where mmm is a series of letters representing a month and dd is a series of numbers representing a day. | The date of the entered string. For example, typing Dec 15 in the year 2018 will return 12/17/18. |
Formulas
| Shortcut (PC & Mac) | Description |
|---|---|
| Ctrl + L | With the insertion point positioned on the column name in the formula, creates an absolute reference (cell reference lock) Inserts $ before the column name (horizontal cell reference lock) =COUNT($[Order Number]4:[Order Number]6) |
| Ctrl + L + L | Inserts $ after column name (vertical cell reference lock) =COUNT([Order Number]$4:[Order Number]6) |
| Ctrl + L + L + L | Inserts $ around column name (full cell reference lock) =COUNT($[Order Number]$4:[Order Number]6) |
Navigate in Card View
Details on Card View are in Using Card View to Visualize Your Project.
| Shortcut (PC & Mac) | Description |
|---|---|
| Arrow keys | Select card |
| Spacebar | Expand or collapse card |
| Enter | Open edit row form |
| Shift + Enter | Add a card (enter a title and press Enter again to add the card) |