Google Sheets – How to Freeze a Row

google sheetskeyboard shortcuts

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 Freeze option in the menu bar?
What are the keyboard shortcuts to freeze/un-freeze rows/cols on Mac/Windows?

Best Answer

The Freeze option is found in the View menu:

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 View menu.)

Related Solutions

Google Sheets – How to Build a Cell Reference Without Knowing Row Number

The ROW function returns the row number of any cell or range.

The syntax is: Row( reference ) but if the reference parameter is omitted, it assumes the cell in which the Row function was entered.

This can be used to refer to cells using indirect, for example =indirect("C" & row()) refers to column C in the current row.

Google Sheets – Sum Cells from Another Row Based on a Cell Value

With the magic of matrix multiplication and this solution (credit where credit is due), I have managed to wrangle it to do what you want.

=ArrayFormula(IF( J4:J = "" ; "" ; MMULT((ROW(G4:G)>=TRANSPOSE(ROW(G3:G)))*((ROW(G4:G)+1-I4:I)<=TRANSPOSE(ROW(G3:G)));G3:G)* ( ( J4:J ) / 10 ) ))

My head hurts already, so I won't go into too much explanatory detail, except to say that the key magic happens in

="MMULT((ROW(Range1)>=TRANSPOSE(ROW(Range2)))*((ROW(Range1)+1-I4:I)<=TRANSPOSE(ROW(Range2)));Range2)))"

And I've added a second sheet to your public one with a rough equation builder, for understanding or alternative applications.

Best Answer

Related Solutions

Google Sheets – How to Build a Cell Reference Without Knowing Row Number

Google Sheets – Sum Cells from Another Row Based on a Cell Value

Related Topic