Add, edit, or clear cell content

Editing cell and sheet content is easier than ever with Smartsheet. 

Who can use this?

Plans:

  • Smartsheet
  • Pro
  • Business
  • Enterprise

Permissions:

  • Editor
  • Admin

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

Add information to a cell

  • Click on a cell to begin typing and entering information. You can also easily copy and paste information into cells.
  • Typing over existing data in a cell will overwrite it. You can always access the previous entry by right-clicking on the cell (Mac users can [Ctrl] + click) and selecting View History.
  • The column type determines the type of data you can enter into the cell. For example, if a column is a date type, you can click on a cell and select a date from a calendar. If the column is a drop-down list type, you can click on a cell to select an option from a list.

  • You can have up to 4,000 characters in each cell.

     

    You can also type text freely into any column type except read-only system columns.

Edit a cell

You can edit the information in a cell directly or by viewing its contents in a form:

  • To open a cell for editing, double-click it or press [F2].
     

    If you single click on the cell, the existing value will be overwritten when you begin typing.

     

  • To change the formatting of a cell, click it, and then click the desired formatting option from the left toolbar. Learn more about formatting options. 

  • To edit the contents of a cell in a form, click the drop-down arrow next to a row's number and select Edit to open the form.

     

    You must have Editor permissions or higher to see the Edit command. If you are shared to a sheet with Viewer permissions, you'll see the View Detail command. Select View Detail to view the details of the row in a form.

     

Clear cell content

Select one or more cells and press Delete or Backspace to clear the current contents. To learn about the clear cell value action, see Clear the contents of a cell with the clear cell value action.

 

You can also right-click a cell and select Clear Contents.

 

Clear row content

To clear the content of an entire row:

  1. Click the row number to the left of the row to highlight it.
  2. Press Delete or Backspace.

This won't delete the row itself, but it will clear all content from the cells in the row.

Clear column content

  1. Click the column header at the top to highlight it.
  2. Press Delete or Backspace.

This won't delete the column itself, but will clear all content from its cells.