Formatting dataĬhoose appropriate formatting options for the data in your tables.Īdd thousand separators to big numbers above a thousand.
However, if you’re working with just a year, as in the example above, you can get away with center aligning, just be consistent. Right align dates (which they are by default). For example, the ID numbers above can be center aligned. they’re not being compared against each other or being used in any sort of calculations. Really the only exception to this rule is for numbers that are not really numbers, i.e. Right align numbers (which they are by default). Let’s align those columns, they’re messy!Ĭenter column headings, ID numbers, or other standardized entries. Go for bold, center-aligned and wrap the text, so it all shows. The goal with this article is to show you how to make a table in Google Sheets look great, like this:
Let’s start with a simple table, completely devoid of any formatting: A collection of formatting tips for how to make a table in Google Sheets.
