hwawidget.blogg.se - Freeze both columns and rows in excel

Click and drag method for freezing rows / columns in Google Sheets We'll start with the click and drag method, and then we'll go over the "View" menu method for the rest of the examples in the lesson.

The two methods for freezing rows and columns in Google Sheetsįirst, let's go over the two different ways to freeze rows and columns in Google Sheets. If you freeze a column, the frozen column will remain on the left as you scroll left and right. If you freeze a row, the frozen row will remain at the top as you scroll up and down. You can choose to freeze 1 or 2, or if you are freezing more than two columns / rows… you will have the option to freeze "Up to" the cell / row / column that you selected before opening the menu)Ĭlick here to get your free Google Sheets cheat sheet

Choose the number of columns or rows that you want to freeze.

Select any cell that is in the column / row that you want to freeze (You may also select the entire row or column).

To freeze rows and / or columns in Google Sheets, follow these steps: You can either use the click and drag method, or you can use the "View" menu, which is the main method that I will use in the examples, but below I will teach you how to use both of these methods. There are two different ways to freeze rows and columns in Google Sheets. In this lesson I am going to show you how to freeze rows, columns, both rows and columns at the same time, and I'll also show you how to unfreeze rows / columns.

This makes it much easier to read your sheets when the data extends beyond the screen view, where you want to be able to always show the row(s) at the top or the column(s) on the left. In Google Sheets, you can freeze rows and columns in your spreadsheet, so that a specified amount of rows and/or columns will stay locked in place when you scroll, such as when you want to lock your header rows, or lock a column on the left side of your sheet.