Typically, you would want to lock the first row to see the column headers when you scroll down the sheet. Bellow you will find the detailed steps that work in any for Excel version. In Microsoft Excel terms, to freeze panes means to always show certain rows and/or columns at the top of a spreadsheet when scrolling. The good news is that you can easily fix that inconvenience by freezing panes in Excel. Hardly anyone will ever use them to the limit, but if your worksheet contains tens or hundreds of rows, the column headers in the top row disappear when you are scrolling down to view lower entries. These tips work in all modern versions of Excel 365, 2021, 2019, 2016, 2013, 20.Īs you probably know, the current versions of Excel allow using more than a million rows and over 16,000 columns per sheet. You will also see how to freeze several panes at a time to make Excel always show certain rows or/and columns when you scroll down or right. You will learn how to quickly lock header row or/and the first column. This feature did not work for row headers and only seems to work with the "Format as Table" option.The tutorial demonstrates quick ways to freeze panes in Excel. Note: If you scroll down or right outside of the table area, the column headers switch to the built-in format. The column names for only the table area should now reflect the first row data.Right-click on the grey row 1 header area and select hide.Select the first row which should be your header row.When the "Format As Table" dialog comes up, select the "My table has headers" checkbox and click the OK button.With a cell in your table selected, click on the "Format as Table" option in the HOME menu.Make the first row the header row that you wish to see in the columns by giving it short meaningful names.Using Microsoft Excel 2013 or later (haven't tried earlier versions), create a table in Excel.However, if you format the entire table as a Table, then Excel has a useful trick to enable such a feature. Excel does not give an easy way of changing your column headings to something other than the built-in A, B, C or 1, 2, 3 (R1C1) format.
0 kommentar(er)
