Another useful formatting tool is conditional formatting. That means telling the spreadsheet that if a certain condition is true, then it should format the cell in a certain way. I most commonly use it to make zeros disappear. By telling… Read moreConditional Formatting

The easiest way to change the formatting on a table or cell in a spreadsheet, if you’re not feeling too picky about the results, is to use ‘Autoformat’, ‘Table/Cell Styles’, ‘Themes’, or whatever automatic formatting option your program gives you…. Read moreAutoformatting

One year ago yesterday, the very first post went up on Swiss Army Spreadsheets. To celebrate this milestone, it seems like a good time to post an index to everything that’s gone up so far.

I was recently asked for ideas on how to present statistics. It’s a good question because, let’s face it, people don’t like numbers. They want information that’s easy to digest…and, almost more importantly, they want information that LOOKS like it’s… Read moreCell & table formatting