There are different ways to copy and paste information in Smartsheetor between Smartsheet and other programs. For general information about how to copy and paste seeCopy and Paste Cells, Rows, Formulas, Hierarchy, or Hyperlinks.
This article includes tips for copying data between Smartsheet and other programs and for how to use Paste Special to customize paste results.
Using copy and paste forcolumns is not supported.
Copy and paste between Smartsheet and other programs
You can also import files to create new sheets.
To copy data between Smartsheet and another program such as Microsoft Excel, use keyboard shortcuts:
- Ctrl+C to copy
- Ctrl+V to paste
When you copy/paste between programs, keep these things in mind:
- Right-click menu commands (Copy and Paste) dont always function as expected when you switch between different applications.
- 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.
Create cell links, copy formula results, or formatting
Use Paste Specialto 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.