Learn valuable tips for copying and pasting.
USM Content
There are different ways to copy and paste information in Smartsheet or between Smartsheet and other programs.
Using copy and paste for columns isn't 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 (or Command+C) to copy
Ctrl+V (or Command+V) to paste
When you copy/paste between programs, keep these things in mind:
- Right-select menu commands, copy, and paste don’t always work as expected when switching between applications.
- If you've copied a multi-line cell in Excel or other programs, double-click the cell in Smartsheet before pasting it. Doing this prevents the lines from spilling over into the cells below.
Create cell links, copy formula results, or formatting
Customize your pasted cell or row content by using Paste Special.
To use Paste Special
- After you copy a cell or row, right-select the destination cell.
- Choose Paste Special.
- Select how you want to paste the cell or row content.
Use the table below to decide which option to use.
| Use this | To do this |
|---|---|
| Values | Paste in the values you’ve copied. For example, there is a formula in the copied cell. Use this option to paste the formula's result into the cell rather than the formula itself. |
| Formats | Paste the formatting from the copied cell, including background color, font color, font style, and more. |
| Links to copied cells | Create cell links to the copied cells. This option is available only when pasting into a different sheet within the same browser tab, provided you have the necessary sharing permissions and are pasting into a column that supports cell links. |
Copy and paste usually works best if you work within the same browser tab.
If you use paste special in table view, you can only paste values or formats, for now.
You now know how to use copy and paste to precisely control which data and formatting you bring into your sheets.