

Use this option to paste the result of the formula into the cell rather than the formula itself. For example, there is a formula in the cell that was copied. Use the table below to decide which option to use.

After you copy a cell or row, right-click the destination cell.Use Paste Special to customize what's included when you paste cell or row content. Doing this will prevent the lines from spilling over into the cells below.Ĭreate cell links, copy formula results, or formatting If you've copied a multi-line cell in Excel or other programs, double-click the cell in Smartsheet before pasting it.Right-click menu commands (copy and paste) don’t always function as expected when you switch between different applications.When you copy/paste between programs, keep these things in mind: To copy data between Smartsheet and another program such as Microsoft Excel, use keyboard shortcuts:

You can also import files to create new sheets. Copy and paste between Smartsheet and other programs Using copy and paste for columns is not supported.
#Copy paste how to#
This article includes tips for copying data between Smartsheet and other programs, and for how to use Paste Special to customize paste results. There are different ways to copy and paste information in Smartsheet or between Smartsheet and other programs.
