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 it to change the font color to match the background whenever the value in the cell is zero, I can make the non-zero entries in a table stand out much more clearly.
Continue reading Conditional 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. This will usually set the background, the font color/size, alignment and the borders of the cells. It usually won’t merge or combine cells If you do it across a whole table it will often use different options for different rows. Continue reading Autoformatting
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. Continue reading Annual index: Year one
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 easy to digest. Just like the cover of a book, something visually attractive can generate more interest than something plain can, even if the contents are the same. Continue reading Cell & table formatting