There are different ways to copy and paste information in Smartsheetor between Smartsheet and other programs. The table below includes anoverview.
NOTE: Currently, using copy and paste forcolumns is not supported.
Use either the right-click menu or the keyboard shortcuts Ctrl + C to copy and Ctrl + V to paste (Command + C and Command + V on a Mac).
Mac users should use Command in place of Ctrl.Copy and paste data between Smartsheet and other programs, such as Microsoft Excel.Keyboard shortcuts
Ctrl + C to copy and Ctrl + V to paste (Command + C and Command + V on a Mac).
Copyand Paste Cells, Rows, Formulas, Hierarchy, and Hyperlinks
Copy and Paste Cells (within a Sheet or Between Sheets)
To copy a cell, right-click and select Copy.
To paste to a cell, single-click on the cell where youd like to paste in the information and press Ctrl+ V(orright-click on the destination cell and select Paste).
Copy Rows within the Same Sheet
NOTE: If you want tocopy rows between differentsheets, please see the article:Copying a Row to Another Sheet.
To copy a row,click the rownumber to highlight the row and then use the keyboard shortcut;or, click the drop-down arrow next to the rows number and select Copy.
To include multiple consecutive rows, click on the top rows number, hold down the Shiftkey and then click on the bottom rownumber to highlight all of the rows in between.
To include multiple non-consecutive rows, hold down the Ctrlkey and then click on each row number youd like to copy.
To paste a row,click on therows number and then use the keyboard shortcutor click thearrow next to the row number and select Paste Row. The copied rowswill be inserted above the row you selected.
Copy and Paste Formulas
Use the instructions above to copy cells and rows containing formulas within the same sheet.
To copy a formula for use in a different sheet:
NOTE:You may need to modify the cell references to make them appropriate for this sheet.
Copy and Paste Hierarchy
Verify that the hierarchy is expanded by clicking the expand icon
in the parent row.
Use the method outlined above to copy/paste multiple rows the parent row should be at the top of your selection, and the last child row should be at the bottom. This will preserve theparent-child relationships between the rows.
TIP: If you often copy/paste the same set of tasks to re-create the hierarchy structure, we suggest saving the hierarchy to a separate sheet. Then, when you need the section added to your current sheet, use theCopy to Another Sheetcommand to move the entire section to your destination sheetthis tip will allow you to copy the hierarchy without needing to expand first. For more information, see the articleCopy Rows to Another Sheet.
Use Paste Special
Paste special enables you to customize what's included when you paste cell or row content.
After you copya cell or row, right-click on the destinationcell and select Paste Special to display thePaste Special window:
Use the table below to decide which option to use.Use thisTo do thisValuesPaste in the values that youve copiedif there is a formula in the cell that was copied, use this option to paste the result of the formula into the cell rather than the formula itself.FormatsPaste in the formatting from the copied cell, such as background color, font color, font style, etc.Links to Copied Cells
Create cell links to the copied cells. This option will only be available if youre pasting into a separate sheet than the one youve copied from, you have the appropriate sharing permissions, and youre pasting into a column that allows cell links.
For more information about creating links between sheets, see the article on cell linking.