Google Sheets Tips Weekly Newsletter & 100 Google Sheets Tips Ebook

These Google Sheet Tips are fantastic!!! Every week, I try to use the new tip / idea / code in one of my projects. Great stuff!
– Chip D.

Join our community of over 30,000 Google Sheets aficionados and get:

  • The Google Sheets Tips email – an actionable tip every Monday 👍 (Think of it as your Monday morning espresso, in spreadsheet form.)
  • Bonus: A free copy of the Spice Up Your Sheet Life ebook, packed with 100 Google Sheets tips (the first 100 from this series) 👍
  • Spice Up Your Sheet Life, Edition 2

  • Exclusive content not found anywhere else on this site 👍
  • Free updates to any templates 👍
  • The best deals on future training courses 👍



Example: Google Sheets Tips email #25

Neat trick with freeze panes

🔥 TIP: Quickly drag the column header row down to freeze panes.

Freeze panes is a useful and simple technique to lock the top row (or rows) of your spreadsheet, so that they remain in view even as you scroll down your datasets. You’re effectively anchoring them in place.

It’s really useful because you can keep your column headings in view as you move about your data.

Traditionally, you freeze panes through the View > Freeze menu, but there is another quicker way.

Hover over the bottom of the column heading letters until you see the hand icon, like this:

Using Google Sheets drag handle to freeze panes

Click and hold down your mouse button, and then drag the thick line down:

Using Google Sheets drag handle to freeze panes

Let go when you’ve reached the row level you want to freeze (in this case, just the top row):

Google Sheets freeze panes

This technique also works for freezing columns!

(This was tip #25 and was originally published on 12 November)