If you’ve ever spent too much time trying to make a Google Sheet look nice, be it for your director or a board meeting….then this is for you.
Below are two lesser-known hacks to help you format spreadsheets like a pro. To see them in action, check out the brief videos from my Youtube channel.
1. Alternating Colors
Alternating Colors is the quick way to create professional-looking tables out of your raw Google Sheets data. This feature lets you add color to header and data rows, with an alternating sequence that makes your lines of data easier to scan.
To use this in Google Sheets: In the menu bar, click Format > Alternating Colors.
2. Format Painter
Format Painter is one of the best kept productivity secrets in Google Sheets. It’s a nifty tool that can copy and paste format settings across cells. Super convenient if you have a cell, row or column formatted in a specific way (color, font, width/height, type) and you need to replicate that in another part of your spreadsheet.
To use this in Google Sheets: Click the cell whose format you want to copy. Then, click the Format Painter Brush icon.
p.s The tips above are part of a series of quick videos on Google Sheets. For the rest of the series, check out Google Sheets: The Basics.