Another formatting element that I’ve mentioned frequently, but not explained, is column width and, by extension, row height.
In a lot of ways wrapping the text, decreasing the font size, and changing the column width are all ways to do the same thing: make more text visible in the table. Text wrapping inherently also involves changing row heights. After all, if you wrapped the text to a new line but didn’t increase the height of the row, that new line wouldn’t be visible. Fortunately if you wrap text it will usually (but not always) automatically increase the height of the row for you. However, if you decrease the amount of text and it no longer has to wrap to a new line, it won’t necessarily automatically decrease the row height. Continue reading Formatting elements: Column Width and Row Height (About)
There are a lot of things you can do with fonts, and a lot of things you can accomplish with them. You can make things prettier, of course (or you can make it hideous, if you go too far), but you can also convey useful information. For example, compare the following two lists. Which one is easier to read? Continue reading Formatting elements: Font (Nifty tricks)
Last week I talked about the various options for formatting the font, and this week I’m going to talk about how to actually access and use them. Continue reading Formatting elements: Font (How to)
In making last week’s post, I realized that I had missed a couple of the formatting types I’d promised to talk about. One of those things was what you can change about fonts, what you can do with them, and how to do them, so that’s what I’m going to start talking about today.
The font determines what your letters and numbers look like. There are four things you can change about fonts: size, color, family, and style. In most programs your changes will affect the whole cell, but a few, like Excel 2010, you can change just parts of the cell. Continue reading Formatting elements: Font (About)
To help illustrate how countif() can be used to generate useful statistics, I’ve created a example.
This example is for a library which has librarians teaching library instruction classes to a variety of group types. The first sheet has the information on who taught which classes on which day, and the second sheet has a couple of tables using countif() to summarize this information. Continue reading Simple statistics: countif example