![]() ![]() Say we wanted to freeze the left three columns (A-C) and the top three rows (1-3) so they’d be visible as we scroll through the spreadsheet. You can freeze groups of row or a groups of columns, but did you know you can freeze multiple rows and columns at the same time? ![]() So if we want columns A through D to stay visible, we select column E and then freeze the panes line before: To freeze a handful of columns instead, click the column to the right of the columns you want frozen, and freeze the panes again. Now head back up to the view menu, select “Freeze Panes” and select “Freeze Panes.”Īs you scroll down the sheet, the top several rows will remain frozen and there will be a gray line that will show where the edge of the frozen panes. So if you want rows 1-4 to freeze, click on row 5 (the number to the left of the row) to select the entire row: To freeze several rows, click on the row number below the bottom-most row that you want to freeze. In some case, you want to freeze multiple rows or columns (or even both). The above two options work in a perfect world, but sometime the data you need visible on screen all the time isn’t the top row or first column. Go back to the “View” tab, select “Freeze Panes” and then select “Freeze First Column.”Īs before, to get things back unfrozen, go back and select “Unfreeze Panes” again. Sometimes the left column has info that you want visible at all times. If you want to reverse that, go back to the “View” menu, click on “Freeze Panes” again and select “Unfreeze Panes” to get things flowing back to normal. Now when you scroll up and down, the top row stays put. Click on the “View” tab, click on “Freeze Panes” and then “Freeze Top Row.” If you want to get the top row to stay put, it’s pretty straight forward. You can freeze multiple rows or multiple columns (or both) to have those visible all the time.Here’s how you can go about doing this.Įxcel lets you freeze things in one of three ways: It can be extremely handy to freeze certain rows or columns so that they won’t move when you’re scrolling through the rest of the spreadsheet. If you are working on large spreadsheets, it can be very easy to get lost and forget what a certain row or column is being used for. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |