reading your data

Hiding columns

Put the columns you don’t need out of sight to read a wide table without scrolling sideways; they stay in the file, and come back with a click.

A table with many columns doesn’t fit in the window, and the two columns you want to compare are seldom side by side. Hide the ones in between: they take no room, the columns after them move left, and the file doesn’t change. A hidden column is still there, and it is saved with the rest.

To leave rows out instead, filter them.

Hiding a column

  • View › Hide Column hides the column of the cursor.
  • In the column bar above the rows, the three dots where a column ends open its menu: Hide Column is the last entry.
  • To hide several at once, select them in the column bar first (click a number, drag over others, or Ctrl+Click⌘Click each one: see Selecting columns and rows) and then use either of the two.

One column always stays in sight: the last one can’t be hidden.

Each column keeps its number and its colour, so the numbers of the column bar skip the hidden ones: 1, 2, 5 says that columns 3 and 4 are there, out of sight.

A file of cities with its columns 2 and 3 hidden: the column bar numbers 1, 4, 5, 6 and 7, with two thin lines between 1 and 4 where the hidden columns are, and the rows go from the city straight to its population

Showing them again

  • Where columns are hidden, the column bar has a mark between their two neighbours: two thin lines, like a seam. Point at it to read which columns are under it, and click it to show them.
  • The status bar says how many are hidden (2 columns hidden). Click it for a list, to show one of them; the × beside it shows them all.
  • View › Show All Columns shows them all too.
The left of the status bar: a pill with a crossed-out eye that says 2 columns hidden, and an × after it, then the cursor’s column, population, and Row 1 of 30

Going to a hidden column shows it again: Go › Go to Column…, the next change of a comparison, a problem of the Quality Check.

Which columns are hidden is remembered with the tab, so they are still hidden after you reload the page or restart the app. They are shown again if you change the delimiter or the header row, and after an operation that leaves the table with other columns (one inserted, deleted, moved, split…), or its undo: the numbers would no longer be of the same columns.

Working with columns hidden

Hiding is a way of looking at the table, not a way of choosing what to work on (a filter is that, for rows).

  • The cursor skips hidden values. The arrow keys, a click, Home and End, and Ctrl+Alt+→⌥⌘→ go from a value that shows to the next one that shows. So an operation on the cursor’s column is never on a column you can’t see, and neither is a column selected in the column bar.
  • Typing beside a hidden value never touches it. What you type goes to the value that shows. Backspace at the start of the value after a hidden one, and Del at the end of the value before it, do nothing: they would join two values across the hidden one. For the same reason two rows can’t be joined while the first or the last column is hidden.
  • A selection that goes over hidden values has them inside, as a folded block in a code editor has its lines. Copy a row and its hidden values are copied; delete rows and they go whole; an operation on the rows you selected, or on the whole table (Ctrl+A⌘A), changes the hidden columns too. Saving saves everything.
  • Find looks in the cursor’s column, as always; with in column off, it looks everywhere but in the hidden columns, so nothing is replaced where you can’t see it. See Find and replace.
  • Row Details lists every value of the row, the hidden ones too, marked hidden: it is the place to read a row whole. You can edit them there.

A row that has values only in hidden columns (a row cut short, or the first value of a row you are typing) is shown whole: there would be nothing of it to see.

Exporting the columns that show

Ctrl+S⌘S always saves every column. With columns hidden, File › Save As… and the formats of File › Download as (File › Export as in the desktop app) have one more option, Columns: every column, or only the columns not hidden. It works for every format, and together with Rows, the option for the rows a filter shows.

A file with only those columns is an export: the tab stays with its own file and all its columns, and the name it proposes ends in “(visible columns)”, so that it doesn’t go over the original. The values are written again from what they hold, so a value between quotes that doesn’t need them is written without them.