EXCEL TABULAR FORM HOW TO

Hidden in the Custom Number Format menu is a conditional formatting option for setting different formats for numbers greater than 0, equal to 0, or less than zero.

EXCEL TABULAR FORM HOW TO

How to make a table in Google Sheets with colors and indicator arrows Select the color scheme you want, whether you have a header or footer row, and even choose custom colors if you wish:

Simply highlight your whole table and then open up the Alternating Colors option sidebar. Sure you can do this manually, but it’s way easier and quicker to do with the Alternating Colors tool under the formatting menu. How to make a table in Google Sheets with Alternating colors However, for tables that are part of dashboard reports or are being presented to clients, you can add colors to match your branding or bring additional context to your numbers. I could stop the article here, as the table is now sufficiently formatted to maximize legibility. For example 2 decimal places if you need that level of detail to show cents on the dollar, but remove decimal places if they’re not needed for large numbers: Add currency signs to financial numbers to add context.Ĭhoose an appropriate number of decimal places. Formatting dataĬhoose appropriate formatting options for the data in your tables.Īdd a thousand separator 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. Really the only exception to this rule is for numbers that are not acting as 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. How to Format a Table in Google Sheets Header rows The goal of 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.

Excel tabular form