Highlight all rows/cells below the row/cell you selected Highlight all rows/cells above the row/cell you selected Selects the entire column of your active or selected cells NOTE: To insert multiple rows at once, press Shift and select multiple row headers, then select Insert. Insert or select rows and columns PC Shortcut 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. Inserts a carriage return or line break in Text/Number cells Outdent the row (you will see the indent level in the Primary Column only) Indent the row (you will see the indent level in the Primary Column only) Takes you to the bottom right cell of a sheet Takes you to the top left cell of a sheet Open the Search dialog for advanced search optionsĭisplay the Go To Row dialog to navigate to a specific row in the sheet Open a sheet, find information, move around in a sheet PC Shortcut Open the Edit Widget dialog for the selected dashboard widget (when dashboard is in Edit mode) Open the Hyperlink dialog for selected cell Another way to use this feature by selecting and dragging the cell from its lower-right corner.

This shortcut is useful when a column contains a formula that you want to use in every cell in that column.The cell containing the value that that you want to fill must be at the top of the selection. Redo the previous action since the last saved version Undo the previous action since the last saved version 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. NOTE: Copying a row does not copy its associated attachments or comments. You can copy rows, cells, formulas, hyperlinks, and hierarchy. You can copy data within a sheet in Smartsheet or between sheets. Mac users should use Command ⌘ instead of Ctrl.Ĭut, copy, paste and other frequently used shortcuts PC Shortcut To save time, use following keyboard shortcut keys in Smartsheet.

Command insert column excel for mac