Given some sheet I'm able to freeze the current row by typing "freeze" into the
Help menu as shown:
But I'm curious:
- Where is the
Freezeoption in the menu bar?
- What are the keyboard shortcuts to freeze/un-freeze rows/cols on Mac/Windows?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
Freeze option is found in the
Unfortunately, there is no keyboard shortcut for freezing/unfreezing any part of the sheet. (The closest is that there is a shortcut to open the
Freeze rows and columns in Google Sheets Mobile app On the Google Sheets Android or iOS app, it’s actually even more easy to freeze a row or column. Here’s how:
Open the sheet and tap on the “Sheet” tab at the bottom.
Now scroll down and you will see two options “Freeze rows” and “Freeze columns”. Click on the upward and downward arrow next to them to select the number of rows and columns you want to freeze. A gray line will indicate the selected rows and columns.
You can decrease or increase the number as needed, and you can unfreeze them by setting the number to 0.