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



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

Read More:

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:

#GoogleSheets #GoogleSheetsTips #Spreadsheet

Nguồn: https://thamdinhgiadonga.com/

Xem thêm bài viết khác: https://thamdinhgiadonga.com/tong-hop/

Article Categories:
Tổng Hợp

All Comments

  • Thank you very much for solving my problem

    World link June 29, 2020 2:35 pm Reply
  • sorry but if Iwan just 10th row freez. can i do that

    Chetan Prajapati June 29, 2020 2:35 pm Reply
  • thank you very much

    Amrita Dey June 29, 2020 2:35 pm Reply
  • Thank you bro

    Jalspiration June 29, 2020 2:35 pm Reply
  • THANK YOU

    Angelika Tamaryan June 29, 2020 2:35 pm Reply
  • When you scroll colum right to left then hide heading name . This is problem. I need that when i scrolling colum the heading name will stuck. how I will do it

    mizan hasan June 29, 2020 2:35 pm Reply
  • Thanks so much!

    Techtrovert June 29, 2020 2:35 pm Reply
  • Thank you so much

    Lynn Chimwadzimba June 29, 2020 2:35 pm Reply
  • You saved me, thanks a lot

    Shadrack Omwenga June 29, 2020 2:35 pm Reply
  • How did you delete the columns from Google Sheets?

    Jennifer Milfort June 29, 2020 2:35 pm Reply
  • thanks this helped a lot 😀

    Halxmon June 29, 2020 2:35 pm Reply
  • Great video!!! Helpful and to the point.

    Maria Garcia June 29, 2020 2:35 pm Reply
  • No messing about. Straight to the point. Well done

    Victor June 29, 2020 2:35 pm Reply
  • easy to follow and very clear, thank you

    Talya Brinkman June 29, 2020 2:35 pm Reply
  • Thank you!

    Dennis Rue June 29, 2020 2:35 pm Reply
  • THANK YOU!!!

    Catherine Denton June 29, 2020 2:35 pm Reply
  • genius thank u

    Kimberly Wong June 29, 2020 2:35 pm Reply
  • Thanks!!!!!

    evanharrison808 June 29, 2020 2:35 pm Reply
  • Thank you !!!!!😀

    R Moo June 29, 2020 2:35 pm Reply
  • Thanks!

    Victor Win June 29, 2020 2:35 pm Reply
  • Thank you. Very straight forward and easy. I only got into 1 min of video and was able to complete the task I wished. Awesome!!

    Amanda Harris June 29, 2020 2:35 pm Reply
  • So easy to understand. Thank you so much! xoxo

    Angela Armstrong June 29, 2020 2:35 pm Reply
  • Thanks

    Sofia Leon June 29, 2020 2:35 pm Reply
  • Great explanation. Thanks!

    Aaron Howell June 29, 2020 2:35 pm Reply
  • Simply brilliant!!!

    Zach Obut June 29, 2020 2:35 pm Reply
  • Thank you!

    Melanie Hall June 29, 2020 2:35 pm Reply
  • Man, you rock it! Thanks a lot! Saved me bunch of time 😉

    Lucky J June 29, 2020 2:35 pm Reply
  • Great video

    Andrew Hall June 29, 2020 2:35 pm Reply
  • Thank you for your excellent method!! However, I would have found it easier to follow had you not presented the action of your cursor as being like that of a fly wavering about to places which were unnecessary, and without purpose and clouded what you were explaining. Sadly, I have seen so many other YouTube presentations spoilt like this…you're not alone…… but excellent method it is!!

    Paul Weedon June 29, 2020 2:35 pm Reply

Leave a Reply

Your email address will not be published. Required fields are marked *