STOP RANGE FROM MOVING

Keep a Fixed Range in Google Sheets (Even After Inserting Rows) with INDIRECT More videos on INDIRECT: https://bettersheets.co/formulas/indirect This episode shows how named ranges in Google Sheets can shift when you insert rows or columns, breaking references to a fixed set of cells like the “latest two months” of sales data. It demonstrates that editing the named range and using absolute references with dollar signs still won’t prevent the named range from moving. The solution is to use the INDIRECT function to reference a specific range by text (e.g., "A2:B3"), which remains unchanged even after inserting new rows above the data. The script also shows how to pull that fixed range from another tab into a dashboard using INDIRECT with a sheet name (e.g., "Sales!A2:B3"), keeping the displayed range stable as new months are added. 00:00 Problem Setup 00:48 Named Range Pitfall 01:21 Why Fixing Fails 01:52 Use INDIRECT Instead 02:22 Dashboard Example 03:00 Stress Test Inserts 03:52 Wrap Up and Subscribe