Insert, Delete, or Rename 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).


Insert 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 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)
       
  5. Click OK.

The new column is inserted to the left or right of the selected column.

After creating a column, you can change its width by double-clicking on the edge of the column header. Note that the width of the default columns (attachments, discussions, indicators) can't be modified.

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 be given the text/number column type. You can change this by double-clicking the column header.

TIP: Press Ctrl + Spacebar (Windows) or Cmd + Spacebar (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


Delete a Column

Here are two options for deleting columns:

  • Delete a Single Column: Click the drop-down arrow underneath the column 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 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. 

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


Rename 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.

Was this article helpful?
YesNo