On the View tab, in the Window group, click Freeze Panes, Freeze Top Row.Ī black line displays under the Top Row to indicate that it is frozen.Your headings must be visible prior to moving to the next step. Press Ctrl + Hometo move to cell A1 (the top of your worksheet).When you scroll down, the headings (Locations, Jan, Feb, Mar, Total) remain visible. In our example, the headings are in Row 1 or the Top Row therefore, the Freeze Top Row feature is used to lock the headings in this worksheet. The Freeze Pane feature in Excel allows you to lock the top row(s) or left-most column(s) so your headings always remain visible while you move to different areas of your worksheet.ģ options are available for Freeze Panes:ĭoes the first row of your worksheet contain a Heading or Title to describe the data in that column? If yes, use Freeze Top Row. These headings need to be visible when entering the sales for each month, as well as when analyzing and interpreting the numbers for each location. Jan, Feb, and Mar describe what the numbers in each column represent. In a large spreadsheet (as shown below), the headings – Locations, Jan, Feb, Mar, Total are no longer visible as you scroll down the worksheet. The Freeze Pane feature locks the Column or Row so the headings remain visible no matter where you scroll in the worksheet. Instead of repeatedly scrolling up and down or left or right to view these headings, use the Freeze Panes feature. Do your Column or Row Headings disappear when you scroll in your Excel worksheet?Īs a spreadsheet grows in size, the headings disappear as you scroll down (or to the right).
0 kommentar(er)
