mdla.blogg.se

Freeze first two rows in excel
Freeze first two rows in excel






freeze first two rows in excel

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.

freeze first two rows in excel

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.








Freeze first two rows in excel