Better tables in Google Sheets with 20 rarely used tips

Whilst it's easy to get started in Google Sheets, creating a robust, faster, optimal table requires many skills that most don't know exist.

Don't format cell by cell with the fill handle, use either auto-expanding table wide formats with alternating colours or conditional formatting, next add data validation for robust entry, figure out formula placing, freeze panes, take advantage of Smart fill, auto-expanding formulas for new rows & cols, use grouping and more skills

I cover some of these tools in this article that I wrote: https://beebole.com/blog/google-sheet...

Example files can be found here: www.xlconsulting-asia.com/youtube-files


00:00 - Introduction
00:53 - Alternating colours
01:48 - Avoid blank columns & rows
02:55 - Add column instructions
03:17 - Date picker & validation
03:56 - Simple & dependent drop-down lists
05:00 - Number validation
05:44 - Colour coding col instructions
06:38 - Formulas at start & end
07:00 - Colour code an entire row
08:19 - Formula autofill suggestions
08:31 - Smart fill (Auto write formulas for you)
09:08 - Autoexpanding formulas for new rows
10:17 - Freeze Panes
10:30 - Number format tricks
12:02 - Support tables for validation & lookups
12:46 - Protect range
13:36 - Grouping
14:18 - Totals at top
14:47 - Avoid subtotals
15:25 - Avoid merging inside the table