![How to freeze first two rows in excel 2017](https://cdn1.cdnme.se/5447227/9-3/14_64e61dfbddf2b36505b4c7c8.png)
![how to freeze first two rows in excel 2017 how to freeze first two rows in excel 2017](https://i.ytimg.com/vi/IaAuiq2uTTM/maxresdefault.jpg)
However, when we want to read a summary of the information, these tables are difficult to work with. When we are sorting, alphabetizing, and filtering, this format is incredibly useful. One example of this is a standard data table that repeats headers and labels for each row. Often, our data comes to us in ways that are better for calculating than they are for reading. 5Download the Combine Multiple Rows Example File.
![how to freeze first two rows in excel 2017 how to freeze first two rows in excel 2017](https://i0.wp.com/cdnssl.ubergizmo.com/wp-content/uploads/2017/01/freeze_panes_first_column.jpg)
4Cleaning Up the Helper Columns and Finalizing the List.2Building the Concatenation Helper Column.Want to fully unlock the power of Microsoft Excel? Check out all of our LinkedIn Learning courses on the topic. To allow the entire sheet scroll normally again, click the Freeze Panes button and choose Unfreeze Panes.Īgain, the ability to freeze rows and columns can really come in handy when working with long and dense spreadsheets. Picking one automatically unfreezes the other. Note that you can’t freeze the top row and top column simultaneously. That locks all the selected rows or columns in place. Then click the Freeze Panes button and choose Freeze Panes. Or, if you want to freeze more than first row or column, first select the rows or columns you want to freeze. After that it will remain onscreen and in place as you scroll vertically through the rest of the document. So if, for example, you want to keep the top row of your sheet stationary, choose Freeze Top Row.
![how to freeze first two rows in excel 2017 how to freeze first two rows in excel 2017](http://www.bradedgar.com/wp-content/uploads/2016/05/How-to-freeze-columns-and-rows-in-Excel.png)
That gives you the choices of Freeze Panes, Freeze Top Row, and Freeze First Column. To do this, go to the View tab and click the Freeze Panes button. A frozen row or column stays visible as you scroll through the rest of the document, letting you easily keep in view the headings for the data you’re working with. Oftentimes you may find yourself scrolling up and down a sheet just to see the column headers for the cells you’re examining.Īn easy solution to this problem is to freeze header rows or columns on your sheet in Excel. When working with a large amount of data in a spreadsheet in Microsoft Excel, it can become difficult to figure out which category or heading the data in a cell corresponds to, especially when the rows or columns you want to compare are far away from each other.
![How to freeze first two rows in excel 2017](https://cdn1.cdnme.se/5447227/9-3/14_64e61dfbddf2b36505b4c7c8.png)