Freeze panes in Google Sheets the easy way

After using Microsoft Excel for over 6 years, transitioning to Google Sheets was extremely challenging for me.

The lack of support for keyboard shortcuts was the biggest challenge and I learned to live with it. The fact that Google Sheets now supports many such shortcuts is a story for another day, but a bigger pain point was dealing with features that would work differently in MS Excel and Google Sheets.

One such feature is Freeze Panes in Google Sheets.

Freeze panes in Google Sheets by dragging column and row headers
Freeze panes in Google Sheets by dragging column and row headers

Anyone who has tried to freeze panes in the two applications knows how fundamentally different the implementation is in the two. Not to forget the fact that Google Sheets doesn’t have a shortcut to freeze panes either.

But Google Sheets did something far better. They made freezing panes much simpler with this handy trick.

You can now completely skip the part where you need to learn how to freeze panes in Google Sheets with the help of their View menu.

If you thought you needed keyboard shortcuts for this in Google Sheets, just watch this to see how a simple drag-and-drop can make it easier.

#business #googlesheets #analytics #excel #tipsandtricks #gsuite #howto #data #productivity

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s