Expert trick - moving columns in tables with lots of columns

[Mark_Turrell]

I like having the columns I am working on at the top of my list of data (the bit bottom left in the UX). However new columns are at the end of the sheet (last column) which requires a lot of scrolling), or get hidden in the mass of columns.

I have one sheet with at least 300 columns (I pull in single value columns for language strings - one way to use up lots of columns).

It used to be hell on wheels to move the columns across manually (at least it is doable).

BUT then I remembered I can zoom out on the browser (+ / -) and then I can see loads of columns at the same time, making it faster to move columns about.

I hope this tip helps!

[ThinhDinh]

Let’s say you have column rowID at 1 and “Name” at 300, temporarily rename the “Name” column to “NameID”, then in the column search bar, search for “ID”, move the NameID to the left of rowID, then change the column back to “Name”.

[Mark_Turrell]

clever!

[Manan_Mehta]

Genius!