Skip to main content

Show, Hide and Reorder Spreadsheet Columns

Choose which columns appear in Spreadsheet View and arrange them in the order you need.

Written by Scottie Elliott

Choose the columns you need in Spreadsheet View and put them in a useful order. Hiding a column only changes what you see. It doesn't delete anything from your items.

Show or Hide Columns

  1. Open the project in Spreadsheet View. See Grid View vs. Spreadsheet View.

  2. Hover over Display Options and click Columns to Display.

  3. Check a column to show it, or uncheck it to hide it.

Columns to Display, with columns grouped under Categorization.

Columns are grouped under Categorization, Common Fields, Pricing and Status Dates. Check or uncheck a group's name to show or hide all its columns at once. Some columns, such as In Budget under Categorization, are hidden until you check them.

Reorder or Resize Columns

  • Reorder: drag a column heading onto the place you want it.

  • Resize: drag the right edge of a column heading.

Good to Know

  • Your view only: column choices are saved in your browser for this company. They don't change what your teammates see, and they don't follow you to another browser or computer.

  • Schedule and Type fields: filter the Schedule or Type column to just one Schedule or Type to see its extra fields. Schedule Fields and Type Fields in Columns to Display control whether those show.

  • Columns you don't see in the menu: some columns depend on your plan or the project's features, such as Product Tags or Ship To. They're missing from the menu and the table when they aren't available.

  • Product Tags filter: hiding the Product Tags column also clears its filter.

Troubleshooting

Problem

What to check

Dragging a heading changes its width

Start the drag away from the heading's right edge, which resizes the column.

I can't drag a column to reorder it

Clear the Schedule or Type filter. Columns can't be reordered while a single Schedule or Type is filtered.

My columns reset

Column choices are saved in the browser. Clearing browser data or using another browser starts with the default columns.


Did this answer your question?