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.
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
Subscribe to this YouTube channel to get updates on Google Sheets Tips and Google Sheets Tutorials videos –
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:
Xem thêm Bài Viết:
- Những ưu thế của khu công nghiệp Gia Thuận thu hút các doanh nghiệp
- My Top 75 Kpop B-Sides of 2019!!
- (Late Shift) Đạo diễn Độ Tày phá đảo 4 lần game đồ hoạ siêu thực, ngập tràn cảnh nóng.
- Chèn hình ảnh, logo, chữ chìm (Chèn Watermark) vào Word
- Cách vào BIOS Setup và Boot Menu cho Laptop Asus | ASUSPRO