Enter your email below to join over our community of over 15,000 data analysts and 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 35 interesting tips and tricks for Microsoft Excel and Google Sheets 👍
- 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:
Click and hold down your mouse button, and then drag the thick line down:
Let go when you’ve reached the row level you want to freeze (in this case, just the top row):
This technique also works for freezing columns!
(This was tip #25 and was originally published on 12 November)
Bonus Ebook: Spice Up Your Sheet Life
This book contains 35 detailed case studies, covering practical and esoteric, easy and difficult, short and long, Excel and Google Sheet tricks and techniques. My hope is that you’ll find some magic in these pages, to inspire you or show you new ways to use spreadsheets you didn’t know were possible.
For example, did you know you can build a language translation tool in a Google sheet? Or create a chart of stock prices in under 30 seconds? All possible and covered in these pages!
What about other weird tricks like looking up leftwards with VLOOKUP? Or lookups with multiple criteria? Writing SQL code in your spreadsheets? Check, check and check. All possible and covered in this book.