Applies to

Smartsheet

Keyboard shortcuts

Use keyboard shortcut keys in Smartsheet.

Who can use this?

Plans:

  • Smartsheet

To save time, use the following keyboard shortcut keys in Smartsheet.

 

Mac users should use Command ⌘ instead of Ctrl.

 


Cut, copy, paste, and other frequently used shortcuts

PC ShortcutMac ShortcutDescription
Ctrl + F1Control + Command + FEnter full screen
Ctrl + F1Control + Command + FExit full screen
Ctrl + XCommand + XCut
Ctrl + CCommand + CCopy

You can copy data within a sheet in Smartsheet or between sheets. You can copy rows, cells, formulas, hyperlinks, and hierarchies.

Note: Copying a row does not copy its associated attachments or comments.
Ctrl + VCommand + VPaste

Tip: If you've copied a multi-line cell in Excel or another program, double-click on the cell in Smartsheet before pasting it in to prevent the lines from spilling over into the cells below.
Ctrl + SCommand + SSaves all unsaved information
F2Fn + F2Enters edit mode on selected cell
Ctrl + ZCommand + ZUndo the previous action since the last saved version
Ctrl + YCommand + YRedo the previous action since the last saved version
Ctrl + DCommand + D

Fill down

Select the cells that you want to fill. The cell containing the value you want to fill must be at the top of the selection.

Tips:

  • This shortcut is useful when a column contains a formula that you want to use in every cell in that column.
  • Another way to use this feature is by selecting and dragging the cell from its lower-right corner.
Ctrl + KCommand + KOpen the Hyperlink dialog for the selected cell
   

Open a sheet, find information, move around in a sheet

PC ShortcutMac ShortcutDescription
Ctrl + /Command + /Open a Sheet
Ctrl + FCommand + FFind information within a sheet
Ctrl + Shift + FCommand + Shift + FOpen the Search dialog for advanced search options
Ctrl + GCommand + GDisplay the Go To Row dialog to navigate to a specific row in the sheet
HomeFn + Left ArrowGo to the first cell of the current row
EndFn + Right ArrowMove to the last cell of the current row
Ctrl + HomeFn + Control + Left ArrowTakes you to the top left cell of a sheet
Ctrl + EndFn + Control + Right ArrowTakes you to the bottom right cell of a sheet
PgUpPage UpMoves you up in a sheet
PgDnPage DownMoves you down in a sheet
Alt +FOption + FOpen the File menu

Work with hierarchy

PC ShortcutMac ShortcutDescription
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 ShortcutMac ShortcutDescription
Ctrl + EnterCommand + EnterInserts 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 Text button on the toolbar at the top of the Smartsheet window.
Ctrl + ICommand + IItalic
Ctrl + UCommand + UUnderline
Ctrl + BCommand + BBold
Alt + 0149Option + 8Inserts a bullet point in the cell

Insert or select rows and columns

PC ShortcutMac ShortcutDescription
InsertControl+ IInserts a row above the selected row 

Note: To insert multiple rows at once, press Shift and select multiple row headers, then select Insert.
 
Ctrl + SpacebarCommand + SpacebarSelects the entire column of your active or selected cells
Ctrl + Shift + Up arrowCommand + Shift + Up arrowHighlight all rows/cells above the row/cell you selected
Ctrl + Shift + Down arrowCommand + Shift + Down arrowHighlight all rows/cells below the row/cell you selected
Shift + SpacebarShift + SpacebarSelects the entire row of your active or selected cells
SpacebarSpacebarDisplay or remove a checkbox, star, or flag in the selected cell
Ctrl + ECommand + EOpen the Edit Row dialog

Work with dates

 

The following shortcuts work in cells of the Date column type.

 

 

These abbreviations currently work only for English terms.

 

Shortcut (PC & Mac)Description
tInserts 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/23, pressing +3 will enter 12/14/23.
-n (minus sign and a number)Enters a date n days before today’s date

For example, if today’s date is 12/11/23, pressing -3 will enter 12/8/23.
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/23, typing “sun” will return 12/10/23.
^yesYesterday's date
tomTomorrow's date
last weekThe current date -7 days
next weekThe 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 17 in the year 2023 will return 12/17/23.

Formulas

PC ShortcutMac Shortcut Description
Ctrl + LCommand + LWith 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 + LCommand + L + LInserts $ after column name (vertical cell reference lock)

=COUNT([Order Number]$4:[Order Number]6)
Ctrl + L + L + LCommand + L + L + L Inserts $ around column name (full cell reference lock)

=COUNT($[Order Number]$4:[Order Number]6)

Navigate in card view

Shortcut (PC & Mac)Description
Arrow keysSelect card
SpacebarExpand or collapse card
EnterOpen the Edit Row dialog
Shift + EnterAdd a subtask to a selected card (enter a title and press Enter again to add the subtask)

Learn more about using card view.

Navigate in dashboards

Shortcut (PC & Mac)Description
TabNavigating the dashboard widget by widget
EnterFocus on a specific widget

Navigate in template preview 

PC shortcutMac shortcutDescription
Ctrl+F6 Command+F6Move focus forward to the next accessible region
Ctrl+Shift+F6Command+Shift+F6Move focus backward to the previous accessible region

German language keyboards

PC shortcutMac shortcutDescription
Ctrl+ßCommand+ ßOutdent
Ctrl+´Command+´Indent

 

These keys will not work in Firefox and Safari browsers.