Inserting, Deleting, and Renaming Columns

The sheet owner and licensed collaborators with Owner or Admin access to the sheet, can do the following with columns:

A sheet can contain up to 200 columns, 5,000 rows, or 200,000 cells (whichever limit is reached first).

Play Icon Jump to video demonstration: Column Types


Inserting a New Column

The option to insert a column won't be available if you don't have a paid license and don't have sufficient permissions (Owner or Admin) on the sheet.

  1. Click the drop-down arrow  underneath any column's header and select Insert Column Right or Insert Column Left. The Insert Column form appears.
  2. Type the column name in the Name column field.
  3. NOTE: A column name can contain up to 50 characters.
  4. Select from the following column types in the Select column type field:
    • Text/number
    • Contact List
    • Date
    • Dropdown List
    • Checkbox
    • Auto-Number/System
    • Visual Symbols (including Flag, Priority, Decision, Status, Direction and Measurement)
       Check out our Support Tip in the Smartsheet Blog:Using Column Symbols

      For more information on the columns listed above, check out the Column Types article.
  5. Click OK. The new column is inserted to the left or right of the selected column.
  6. After creating a column, you can change its width by double-clicking on the edge of the column header. Alternatively, click on the edge of the column header, and drag the column to the desired width. The width of the Smartsheet default columns (attachments, discussions, indicators) can't be modified.
  7. Apply formatting to the column to display background colors, bold/italic fonts, or to format numbers as currency or percentages (among other options).

To insert multiple columns at once: 

  1. Highlight the number of columns you'd like to insert. (To do this, hold down the [Ctrl] (Windows) or [Cmd] (Mac) key on your keyboard as you single-click column headers one by one to highlight them.)
  2. Click the drop-down arrow under any of the highlighted column headers and select Insert x Columns Left or Insert x Columns Right.

All inserted columns will be assigned a default name (for example, Column12) and the text/number column type. You can change this by double-clicking a column's header or by clicking the drop-down arrow underneath a column's header and selecting Edit Column Properties.

TIP: Press [Ctrl] + [Space Bar] (Windows) or [Cmd] + [Space Bar] (Mac) to select the entire column of your active or selected cells. This makes it easy to delete or copy all column content at once.

Back to top


Deleting a Column

Here are two options for deleting columns:

  • Delete a Single Column: Click the drop-down arrow underneath a column's header and select Delete Column. The column and any data in the column is deleted.

  • Delete Multiple Columns at Once: Hold down the [Ctrl] key as you click on up to five column headers to delete them all at once. 

TIP: To clear the content from a column without deleting it, first click on the column's header to select it (or select multiple columns as described above) and then press the [Backspace] or [Delete] key on your keyboard.

NOTE: You can undo a delete or clear column action as long as you undo it before you save. 

Smartsheet default columns (attachments, discussions, and row actions) can't be deleted but they can be hidden by clicking the drop-down arrow underneath the column's header.

Back to top


Renaming a Column

A column name can contain up to 50 characters.

  1. Click the drop-down arrow underneath the column's header and select Rename Column. The Column Properties form appears.

    TIP: Alternately, you can double-click the column header to bring up this form.
     
  2. Rename the column header in the Name column field, and then click OK.

Video Demo

For an instructional overview on the different column types, please review the video below:

Back to top