Smartsheet melds the best choices of Excel, Google Sheets, and challenge control equipment. Recall to mind it as Excel or Google Sheets on steroids. Central to its efficiency is an array of difficult shortcuts designed to streamline your workflow.
In this submit, we’ll delve into the crucial Smartsheet shortcuts that can help you liberate the entire potential of this transformative tool.
Check out Smartsheets without spending a dime.
In most cases Used Shortcuts
Movement | House home windows | Mac |
---|---|---|
Enter fullscreen mode | Control + F1 | Command + Shift + F |
Move out fullscreen mode | Control + F1 | Command + Shift + F |
Reduce | Control + X | Command + X |
Replica [1 – More info] | Control + C | Command + C |
Paste [2 – More info] | Control + V | Command + V |
Save all | Control + S | Command + S |
Enter Edit Mode for made up our minds on mobile | F2 | Fn + F2 |
Undo previous movement | Control + Z | Command + Z |
Redo previous movement | Control + Y | Command + Y |
Fill down [3 – More info] | Control + D | Command + D |
Open hyperlink dialog | Control + Adequate | Command + Adequate |
Open Edit Widget dialog [4 – More info] | Enter | |
Indent row | Control + ] | Command + ] |
Outdent row | Control + [ | Command + [ |
Insert carriage return or line break [5 – More info] | Control + Enter | Command + Enter |
Follow Italic | Control + I | Command + I |
Follow Underline | Control + U | Command + U |
Follow Bold | Control + B | Command + B |
Insert bullet degree | Alt + 8 | Selection + 8 |
- You’ll be capable of replica wisdom each within the an identical sheet or between different sheets. This contains rows, cells, components, links, and structures. However, if you replica a row, its attachments and comments received’t be built-in.
- For those who replica a mobile with a couple of strains from Excel or any other tool, double-click on the Smartsheet mobile where you need to stay it. This stops the strains from overflowing into the cells underneath.
- To fill cells with a value or machine, select them, ensuring the availability is on the most efficient, or simply drag from the mobile’s bottom-right corner.
- This most simple functions when the dashboard is in edit mode.
- To view line breaks inside the sheet, click on at the ‘Wrap Text’ button on the Smartsheet toolbar on the most efficient. This adjusts the mobile to show all its content material subject matter.
[/su_table]
Rows and Columns
Movement | House home windows | Mac |
---|---|---|
Insert row above made up our minds on row [1 – More info] | Insert | Command + I |
Choose entire column of vigorous or made up our minds on cells | Control + Space | Command + Space |
Highlight all rows/cells above made up our minds on row/mobile | Control + Shift + ↑ | Command + Shift + ↑ |
Highlight all rows/cells beneath made up our minds on row/mobile | Control + Shift + ↓ | Command + Shift + ↓ |
Choose entire row of vigorous or made up our minds on cells | Shift + Space | |
Toggle checkbox, famous person, or flag in made up our minds on mobile | Space | |
Open Edit Row dialog | Control + E | Command + E |
- As a way to upload numerous rows together, grasp Shift, make a choice the row headers you need, and then click on on Insert.
Date Formats
The following shortcuts are suitable in cells of the Date column sort.
Movement | House home windows and Mac |
---|---|
Insert nowadays’s date | t |
Enter a date n days after nowadays [1 – Example] | + followed by way of amount |
Enter a date n days quicker than nowadays [2 – Example] | – followed by way of amount |
Enter date very similar to a day of the current week [3 – Example] | sun , mon , tue , wed , thu , fri , sat |
Enter the day gone by’s date | positive |
Enter the next day to come’s date | tom |
Enter date 7 days quicker than the prevailing date | final week |
Enter date 7 days after the prevailing date | next week |
Enter date in line with provided string [4 – Example] | mmm dd |
- If nowadays is
12/11/23
and likewise you press+3
, it’s going to interchange to12/14/23
. - If nowadays is
12/11/23
and likewise you press-3
, it’s going to interchange to12/8/23
. - If nowadays is
12/11/23
and likewise you typesun
, you’ll get12/10/23
. - Typing Dec 17 in 2023 provides you with 12/17/23.
Card View
Movement | House home windows and Mac |
---|---|
Choose a card | Arrow keys |
Magnify or collapse a card | Space |
Open the “Edit Row” dialog | Enter |
Add a card (type a reputation and press “Enter” all over again to make sure) | Shift + Enter |
Dashboards
Movement | House home windows and Mac |
---|---|
Navigate from one dashboard widget to a couple different | Tab |
Point of interest on a selected widget | Enter |
Get right of entry to the “Shortcut” widget | Enter > Tab > Space |
Get right of entry to the “Metric” widget | Enter > Tab > Space |
Get right of entry to the “Rich Text” widget | Enter > Tab > Space |
Get right of entry to the settings of the “Image” widget | Enter > Space |
Template
Movement | House home windows | Mac |
---|---|---|
Shift focus to the next to be had space | Control + F6 | Command + F6 |
Shift focus to the previous to be had space | Control + Shift + F6 | Command + Shift + F6 |
Check out Smartsheets without spending a dime.
Identical Reads:
- Maximizing Industry Potency with SmartSheet
- Smartsheet vs. Google Sheets
- Mechanically Replace Smartsheet from Google Sheets
The submit 20+ Smartsheet Keyboard Shortcuts gave the impression first on Hongkiat.
Supply: https://www.hongkiat.com/blog/keyboard-shortcuts-smartsheets/
0 Comments