<\/figure>\n\n\n\nThere are a few ways to fix it.<\/p>\n\n\n\n
Freeze the top row with a table<\/h2>\n\n\n\n When you create a table (Insert >> Tables >> Table<\/strong>), and start scrolling, the header turns grey, but it stays on the top, instead of disappearing.<\/p>\n\n\n\n <\/figure>\n\n\n\nFreeze the top row<\/h2>\n\n\n\n If you don\u2019t want to create a table from the data, or just want to keep the header with the same formatting as before, you can go to View >> Window >> Freeze Panes<\/strong> and click Freeze Top Row<\/strong>.<\/p>\n\n\n\nThis action will lock the first row of the spreadsheet across all columns from A<\/strong> to XFD<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nFreeze the first column<\/h2>\n\n\n\n Similarly, you can freeze the first column. Go to View >> Window >> Freeze Panes<\/strong>, but instead of choosing Freeze Top Row<\/strong>, choose Freeze First Column<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nFreeze several columns and rows<\/h2>\n\n\n\n So far so good, but let\u2019s say that the cells in the first two rows are merged. When you use the Freeze Top Row<\/strong> method, there are going to be problems.<\/p>\n\n\n\n <\/figure>\n\n\n\nThe cells First Name<\/strong> and Last Name<\/strong> occupy two rows and Age<\/strong> and (years)<\/strong> are inside single cells. When you try to lock the top row, you will get strange results:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe can easily fix this problem by using another option, called Freeze Panes<\/strong>, located under the same button.<\/p>\n\n\n\nBefore you do that, click cell A3<\/strong> and choose the option. If you try to freeze panes while your active cell isn\u2019t in column A<\/strong>, all columns on the left will also be frozen. This way you can lock both horizontal and vertical headings simultaneously.<\/p>\n\n\n\n <\/figure>\n\n\n\nUnfreeze panes<\/h2>\n\n\n\n If you want to get rid of the frozen panes, you can click the Unfreeze Panes<\/strong> button and all the rows and columns will be restored.<\/p>\n\n\n\n <\/figure>\n","protected":false},"excerpt":{"rendered":"When you have to work with a large Excel spreadsheet, you can easily lose track of exactly what kind of information is included…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\n
Freeze or Fix Column or Row Headings in Excel<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n