How to Freeze Rows and Columns in Google Sheets (Lock Headers in Google Sheets)

Article Link: spreadsheetpoint.com/how-to-freeze-rows-in-goog…

In this video, you'll learn how to quickly freeze rows and columns in Google Sheets using a mouse drag and drop and the option in tabs.

This allows you to lock the headers so that they don't disappear when you scroll away from it.

00:00 Intro
00:10 Why you need to freeze headers
00:35 Mouse drag and drop method
01:50 Freeze Option in the Menu

You may want to freeze rows in Google Sheets if you’re working with a large dataset that requires you to scroll up and down a lot.

Freezing rows at the top would make those rows visible all the time so that you never lose a track of what column represents what metrics.

To use the mouse to freeze rows/columns in Google Sheets, go to the top left part of the sheet where you’ll see an empty gray box. Note that there are two thick gray lines in that box (on the right and to the left). All you need to do is hover your mouse on the gray line, and when you see the hand icon, left-click and drag it down. This will instantly freeze all the rows above the gray line

Read More: spreadsheetpoint.com/how-to-freeze-rows-in-goog…

Subscribe to this YouTube channel to get updates on Google Sheets Tips and Google Sheets Tutorials videos - youtube.com/c/spreadsheetpoint

This channel is meant for people who want to learn about Google Sheets and be more productive in their day to day life. It covers a range of Google Sheets topics such as useful Google Sheets features, Google Sheets functions, Google Sheets formulas, Pivot table, Google Apps Script,.Shortcuts, Google Sheets Charting, Data Analysis, etc. Please subscribe to this channel and never miss a new video on Google Spreadsheets

You can also find a lot of useful resources on Google Sheets here: spreadsheetpoint.com/

#GoogleSheets #GoogleSheetsTips #Spreadsheet