Enter some data into column A, scroll to the right, and you'll see the data move with you. The entire column A area is frozen, indicated by the black border between column A and B. To freeze the first column of a worksheet: In addition to freezing the first row of a worksheet, you can also freeze the first column just as easily.
The data in row 1 remains visible as you scroll down because the entire row is pinned to the top of Excel. If you're using Excel for Mac, skip this step.Ī border appears just below Row 1 to indicate that the area above the line has been frozen. Follow these three easy steps to get that header to stay in place. Freeze the Top Row of a Worksheetįreezing the top row of a worksheet is a great way to keep your Excel headings visible at all times.
#How to freeze a column on excel with header mac for mac#
Instructions in this article apply to Excel 2019, 2016, 2013, 2010, 2007 Excel Online and Excel for Mac 2016 and later. Freezing locks specific columns or rows in place so that no matter where you scroll they're always visible on the top or side of the sheet. To avoid this problem, freeze the rows and columns. When working with large Excel spreadsheets, the column and row headings located at the top and down the left side of the worksheet disappear if you scroll too far to the right or too far down. Freeze panes to keep track of where you are in a spreadsheet
0 kommentar(er)
