28K views · 338 reactions | Lock the top row in place by freezing panes. You can also lock the first column with Alt, W, F, C. Freeze any combination of columns and rows by using Alt, W, F, F. Using that option, Excel will lock rows and columns in place depending on where your active cell is. You can do the same thing in Google Sheets by using the View menu and then select Freeze. #excel #workhacks #googlesheets #shortcuts | Spreadsheet Nation | Facebook