Editing cell and sheet content is easier than ever with Smartsheet.
USM Content
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.
Изменить ячейку
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.
Оставлять комментарии могут только пользователи с разрешениями уровня "Редактор" или выше. 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.
Удалить содержимое
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:
- Click the row number to the left of the row to highlight it.
- 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
- Click the column header at the top to highlight it.
- Press Delete or Backspace.
This won't delete the column itself, but will clear all content from its cells.