Skip to main content
All CollectionsEdit and Format a Table
Hide, Re-order, Sort, Filter, Merge Columns
Hide, Re-order, Sort, Filter, Merge Columns

You can hide, re-order, sort, filter, or merge columns to effectively organize and analyze your data in the way you want to

Updated over 3 months ago

Hide Columns

  1. Right-click a column you want to hide

  2. At the bottom of the options menu, click Hide

Or…

  1. Select columns above the table

  2. Toggle the columns on or off individually or click Hide all to quickly adjust the entire table

To unhide columns, click Show All or toggle the columns on or off

Reorder Columns

  1. Right-click a column you want to reorder and move it left or right

Or…

  1. Select columns above the table

  2. Drag the column you want up or down

Sort

Text

  1. Click Sort above the table

  2. Select which text column you want to sort

  3. Sort A → Z or Z → A

Number

  1. Click Sort above the table

  2. Select which number column you want to sort

  3. Sort 0→ 9 or 9 → 0

Filters

Text

  1. Click Filter above the table

  2. Select a column to filter

  3. Choose between equal to, not equal to, contains, does not contain, is empty, is not empty and enter a value into the field

Number

  1. Click Filter above the table

  2. Select a number column to filter

  3. Choose between Equal to, not equal to, greater than, greater or equal to, less than, less or equal to, is empty, is not empty and enter a value in the field

Merge Columns

  1. Click Add Column > Merge columns

  2. Input formula to combine two columns

Need More Help?

Need More Help? Chat with us below or email us at [email protected]

Did this answer your question?