{"id":69868,"date":"2023-11-06T18:01:41","date_gmt":"2023-11-06T10:01:41","guid":{"rendered":"https:\/\/www.hongkiat.com\/blog\/?p=69868"},"modified":"2023-10-16T23:22:42","modified_gmt":"2023-10-16T15:22:42","slug":"keyboard-shortcuts-smartsheets","status":"publish","type":"post","link":"https:\/\/www.hongkiat.com\/blog\/keyboard-shortcuts-smartsheets\/","title":{"rendered":"20+ Smartsheet Keyboard Shortcuts"},"content":{"rendered":"

Smartsheet<\/a> melds the best features of Excel, Google Sheets, and project management tools<\/a>. Think of it as Excel or Google Sheets on steroids. Central to its efficiency is an array of powerful shortcuts designed to streamline your workflow.<\/p>\n

\"Smartsheets<\/figure>\n

In this post, we\u2019ll delve into the essential Smartsheet shortcuts that can help you unlock the full potential of this transformative tool.<\/p>\n

<\/i> Try Smartsheets for free. <\/span><\/a><\/p>\n

\n

Commonly Used Shortcuts<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Action<\/th>\nWindows<\/th>\nMac<\/th>\n<\/tr>\n<\/thead>\n
Enter fullscreen mode<\/td>\nControl<\/span> + F1<\/span><\/td>\nCommand<\/span> + Shift<\/span> + F<\/span><\/td>\n<\/tr>\n
Exit fullscreen mode<\/td>\nControl<\/span> + F1<\/span><\/td>\nCommand<\/span> + Shift<\/span> + F<\/span><\/td>\n<\/tr>\n
Cut<\/td>\nControl<\/span> + X<\/span><\/td>\nCommand<\/span> + X<\/span><\/td>\n<\/tr>\n
Copy [1 \u2013 More info]<\/a><\/sub><\/td>\nControl<\/span> + C<\/span><\/td>\nCommand<\/span> + C<\/span><\/td>\n<\/tr>\n
Paste [2 \u2013 More info]<\/a><\/sub><\/td>\nControl<\/span> + V<\/span><\/td>\nCommand<\/span> + V<\/span><\/td>\n<\/tr>\n
Save all<\/td>\nControl<\/span> + S<\/span><\/td>\nCommand<\/span> + S<\/span><\/td>\n<\/tr>\n
Enter Edit Mode for selected cell<\/td>\nF2<\/span><\/td>\nFn<\/span> + F2<\/span><\/td>\n<\/tr>\n
Undo previous action<\/td>\nControl<\/span> + Z<\/span><\/td>\nCommand<\/span> + Z<\/span><\/td>\n<\/tr>\n
Redo previous action<\/td>\nControl<\/span> + Y<\/span><\/td>\nCommand<\/span> + Y<\/span><\/td>\n<\/tr>\n
Fill down [3 \u2013 More info]<\/a><\/sub><\/td>\nControl<\/span> + D<\/span><\/td>\nCommand<\/span> + D<\/span><\/td>\n<\/tr>\n
Open hyperlink dialog<\/td>\nControl<\/span> + K<\/span><\/td>\nCommand<\/span> + K<\/span><\/td>\n<\/tr>\n
Open Edit Widget dialog [4 \u2013 More info]<\/a><\/sub><\/td>\nEnter<\/span><\/td>\n<\/tr>\n
Indent row<\/td>\nControl<\/span> + ]<\/span><\/td>\nCommand<\/span> + ]<\/span><\/td>\n<\/tr>\n
Outdent row<\/td>\nControl<\/span> + [<\/span><\/td>\nCommand<\/span> + [<\/span><\/td>\n<\/tr>\n
Insert carriage return or line break [5 \u2013 More info]<\/a><\/sub><\/td>\nControl<\/span> + Enter<\/span><\/td>\nCommand<\/span> + Enter<\/span><\/td>\n<\/tr>\n
Apply Italic<\/td>\nControl<\/span> + I<\/span><\/td>\nCommand<\/span> + I<\/span><\/td>\n<\/tr>\n
Apply Underline<\/td>\nControl<\/span> + U<\/span><\/td>\nCommand<\/span> + U<\/span><\/td>\n<\/tr>\n
Apply Bold<\/td>\nControl<\/span> + B<\/span><\/td>\nCommand<\/span> + B<\/span><\/td>\n<\/tr>\n
Insert bullet point<\/td>\nAlt<\/span> + 8<\/span><\/td>\nOption<\/span> + 8<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    \n
  1. You can copy information either within the same sheet or between different sheets. This includes rows, cells, formulas, links, and structures. However, if you copy a row, its attachments and comments won\u2019t be included.<\/li>\n
  2. If you copy a cell with multiple lines from Excel or another tool, double-click on the Smartsheet cell where you want to paste it. This stops the lines from overflowing into the cells underneath.<\/li>\n
  3. To fill cells with a value or formula, select them, ensuring the source is at the top, or simply drag from the cell\u2019s bottom-right corner.<\/li>\n
  4. This only functions when the dashboard is in edit mode.<\/li>\n
  5. To view line breaks in the sheet, click the \u2018Wrap Text\u2019 button on the Smartsheet toolbar at the top. This adjusts the cell to show all its content.<\/li>\n<\/ol>\n\n
    \n

    Rows and Columns<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n
    Action<\/th>\nWindows<\/th>\nMac<\/th>\n<\/tr>\n<\/thead>\n
    Insert row above selected row [1 \u2013 More info]<\/a><\/sub><\/td>\nInsert<\/span><\/td>\nCommand<\/span> + I<\/span><\/td>\n<\/tr>\n
    Select entire column of active or selected cells<\/td>\nControl<\/span> + Space<\/span><\/td>\nCommand<\/span> + Space<\/span><\/td>\n<\/tr>\n
    Highlight all rows\/cells above selected row\/cell<\/td>\nControl<\/span> + Shift<\/span> + \u2191<\/span><\/td>\nCommand<\/span> + Shift<\/span> + \u2191<\/span><\/td>\n<\/tr>\n
    Highlight all rows\/cells below selected row\/cell<\/td>\nControl<\/span> + Shift<\/span> + \u2193<\/span><\/td>\nCommand<\/span> + Shift<\/span> + \u2193<\/span><\/td>\n<\/tr>\n
    Select entire row of active or selected cells<\/td>\nShift<\/span> + Space<\/span><\/td>\n<\/tr>\n
    Toggle checkbox, star, or flag in selected cell<\/td>\nSpace<\/span><\/td>\n<\/tr>\n
    Open Edit Row dialog<\/td>\nControl<\/span> + E<\/span><\/td>\nCommand<\/span> + E<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
      \n
    1. To add several rows together, hold Shift<\/span>, choose the row headers you want, and then click Insert.<\/li>\n<\/ol>\n
      \n

      Date Formats<\/h2>\n

      The following shortcuts are applicable in cells of the Date column type<\/a>.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
      Action<\/th>\nWindows and Mac<\/th>\n<\/tr>\n<\/thead>\n
      Insert today\u2019s date<\/td>\nt<\/span><\/td>\n<\/tr>\n
      Enter a date n days after today [1 \u2013 Example]<\/a><\/sub><\/td>\n+<\/span> followed by number<\/em><\/td>\n<\/tr>\n
      Enter a date n days before today [2 \u2013 Example]<\/a><\/sub><\/td>\n\u2013<\/span> followed by number<\/em><\/td>\n<\/tr>\n
      Enter date corresponding to a day of the current week [3 \u2013 Example]<\/a><\/sub><\/td>\nsun<\/code>, mon<\/code>, tue<\/code>, wed<\/code>, thu<\/code>, fri<\/code>, sat<\/code><\/td>\n<\/tr>\n
      Enter yesterday\u2019s date<\/td>\nyes<\/code><\/td>\n<\/tr>\n
      Enter tomorrow\u2019s date<\/td>\ntom<\/code><\/td>\n<\/tr>\n
      Enter date 7 days before the current date<\/td>\nlast week<\/code><\/td>\n<\/tr>\n
      Enter date 7 days after the current date<\/td>\nnext week<\/code><\/td>\n<\/tr>\n
      Enter date based on provided string [4 \u2013 Example]<\/a><\/sub><\/td>\nmmm dd<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
        \n
      1. If today is 12\/11\/23<\/code> and you press +3<\/code>, it will change to 12\/14\/23<\/code>.<\/li>\n
      2. If today is 12\/11\/23<\/code> and you press -3<\/code>, it will change to 12\/8\/23<\/code>.<\/li>\n
      3. If today is 12\/11\/23<\/code> and you type sun<\/code>, you\u2019ll get 12\/10\/23<\/code>.<\/li>\n
      4. Typing Dec 17 in 2023 gives you 12\/17\/23.<\/li>\n<\/ol>\n
        \n

        Card View<\/h2>\n\n\n\n\n\n\n\n\n
        Action<\/th>\nWindows and Mac<\/th>\n<\/tr>\n<\/thead>\n
        Select a card<\/td>\nArrow keys<\/td>\n<\/tr>\n
        Expand or collapse a card<\/td>\nSpace<\/span><\/td>\n<\/tr>\n
        Open the \u201cEdit Row\u201d dialog<\/td>\nEnter<\/span><\/td>\n<\/tr>\n
        Add a card (type a title and press \u201cEnter\u201d again to confirm)<\/td>\nShift<\/span> + Enter<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
        \n

        Dashboards<\/h2>\n\n\n\n\n\n\n\n\n\n\n
        Action<\/th>\nWindows and Mac<\/th>\n<\/tr>\n<\/thead>\n
        Navigate from one dashboard widget to another<\/td>\nTab<\/span><\/td>\n<\/tr>\n
        Focus on a specific widget<\/td>\nEnter<\/span><\/td>\n<\/tr>\n
        Access the \u201cShortcut\u201d widget<\/td>\nEnter<\/span> > Tab<\/span> > Space<\/span><\/td>\n<\/tr>\n
        Access the \u201cMetric\u201d widget<\/td>\nEnter<\/span> > Tab<\/span> > Space<\/span><\/td>\n<\/tr>\n
        Access the \u201cRich Text\u201d widget<\/td>\nEnter<\/span> > Tab<\/span> > Space<\/span><\/td>\n<\/tr>\n
        Access the settings of the \u201cImage\u201d widget<\/td>\nEnter<\/span> > Space<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
        \n

        Template<\/h2>\n\n\n\n\n\n\n
        Action<\/th>\nWindows<\/th>\nMac<\/th>\n<\/tr>\n<\/thead>\n
        Shift focus to the next accessible region<\/td>\nControl<\/span> + F6<\/span><\/td>\nCommand<\/span> + F6<\/span><\/td>\n<\/tr>\n
        Shift focus to the previous accessible region<\/td>\nControl<\/span> + Shift<\/span> + F6<\/span><\/td>\nCommand<\/span> + Shift<\/span> + F6<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

        <\/i> Try Smartsheets for free. <\/span><\/a><\/p>\n

        \n
        \n
        Smartsheets Alternatives:<\/div>\n
        \n