As I said before, the concatenate function can be used in a great many useful ways, and one of those ways is to make it easier to sort. There are two things which often annoy me when I’m doing frequent… Read moreConcatenate function for sorting

Even if you do have column headers, once you scroll down more than a screen you can’t see them anymore. Unless, that is, you freeze them. Freezing allows you to specify any number of currently showing rows and/or columns to… Read moreFreezing rows and columns: Basic how-to

In response to the last post, one commenter asked whether the name of a column was the name of the group of cells in the column, or the name of each individual cell in the column. The answer is…both!

When you’re making a detailed list, column headers are extremely important. It’s possible to do without them, but after four columns or so I usually find myself studying the contents and saying “Now, WHAT did this column contain? Likewise, when… Read moreWhy to name columns