{"id":3140,"date":"2019-09-26T18:00:28","date_gmt":"2019-09-27T00:00:28","guid":{"rendered":"https:\/\/www.brendapenman.com\/blog\/?p=3140"},"modified":"2021-11-21T15:40:56","modified_gmt":"2021-11-21T22:40:56","slug":"excel_freeze_panes","status":"publish","type":"post","link":"https:\/\/www.brendapenman.com\/blog\/excel_freeze_panes\/","title":{"rendered":"Keep Row and Column Headings Visible in Excel"},"content":{"rendered":"

[et_pb_section fb_built=”1″ _builder_version=”3.24″ custom_margin=”0px||0px” custom_padding=”0px||0px” global_colors_info=”{}”][et_pb_row _builder_version=”3.25″ collapsed=”off” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

Do your Column or Row Headings disappear when you scroll in your Excel worksheet?<\/p>\n

As a spreadsheet grows in size, the headings disappear as you scroll down (or to the right). Instead of repeatedly scrolling up and down or left or right to view these headings, use the Freeze Panes<\/strong> feature.<\/p>\n

The Freeze Pane<\/strong> feature locks the Column or Row so the headings remain visible no matter where you scroll in the worksheet.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FreezePanes1.png” align=”center” _builder_version=”3.29.3″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

In a large spreadsheet (as shown below), the headings \u2013 Locations, Jan, Feb, Mar, Total are no longer visible<\/strong> as you scroll down the worksheet.<\/p>\n

Jan, Feb, and Mar describe what the numbers in each column represent. 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.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FreezePanes2.png” _builder_version=”3.29.3″ global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

<\/strong>The Freeze Pane<\/strong> 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.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

<\/strong>3 options are available for Freeze Panes:<\/p>\n

* Freeze Panes<\/strong><\/p>\n

* Freeze Top Row<\/strong><\/p>\n

* Freeze First Column<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”3.29.3″ global_colors_info=”{}”][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

How to Freeze the Top Row:<\/h2>\n

[\/et_pb_text][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

Does the first row of your worksheet contain a Heading or Title to describe the data in that column?<\/p>\n

If yes, use Freeze Top Row<\/strong>.<\/p>\n

In our example, the headings are in Row 1 or the Top Row; therefore, the Freeze Top Row<\/strong> feature is used to lock the headings in the worksheet. When scrolling down, the headings (Locations, Jan, Feb, Mar, Total) remain visible.<\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FreezePanes3.png” align=”center” _builder_version=”3.29.3″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,3_4″ _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”|700|||||||” text_text_color=”#00a4e4″ text_font_size=”31px” text_orientation=”center” text_text_shadow_style=”preset2″ global_colors_info=”{}”]<\/p>\n

1.<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

Press Ctrl + Home<\/strong> to move to cell A1 (the top of your worksheet).
Your headings must be visible prior to moving to the next step.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,3_4″ _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”|700|||||||” text_text_color=”#00a4e4″ text_font_size=”31px” text_orientation=”center” text_text_shadow_style=”preset2″ global_colors_info=”{}”]<\/p>\n

2.<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_padding=”0px|||||” global_colors_info=”{}”]<\/p>\n

On the View<\/strong> tab, in the Window<\/strong> group, click Freeze Panes,<\/strong> Freeze Top Row<\/strong>.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FreezePanes4.png” align=”center” _builder_version=”3.29.3″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

A line<\/strong> displays under the Top Row<\/strong> to indicate that it is frozen.<\/p>\n

In our example, the headings in row 1 remain frozen as you scroll down to view the data in rows 11, 12, and 13.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FreezePanes8.png” align=”center” _builder_version=”3.29.3″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

Note:<\/strong> The Freeze Top Row<\/strong> feature freezes the top row that is displayed.<\/p>\n

For example, if Row 10 is the Top Row displayed in your worksheet, Row 10 is the row that is locked.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FreezePanes9.png” align=”center” _builder_version=”3.29.3″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.29.3″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

Recommendation:<\/strong> Press Ctrl + Home<\/strong> prior to using the Freeze Top Row<\/strong> feature.<\/p>\n

Note:<\/strong> When you freeze a worksheet, it has no effect on how the worksheet is printed.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”3.29.3″ custom_margin=”0px||||false|false” custom_padding=”0px||||false|false” global_colors_info=”{}”][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

How to Freeze the First Column:<\/h2>\n

[\/et_pb_text][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

Does the first column of your worksheet contain a Heading or Title to describe the data in that row?<\/p>\n

If yes, use Freeze First Column<\/strong>.<\/p>\n

In our example, the headings are in Column A or the First Column; therefore, the Freeze First Column<\/strong> feature is used to lock the headings in this worksheet. When you scroll to the right, the headings (Locations, Jan, Feb, Mar, Total) remain visible.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FreezePanes10.png” align=”center” _builder_version=”3.29.3″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,3_4″ _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”|700|||||||” text_text_color=”#00a4e4″ text_font_size=”31px” text_orientation=”center” text_text_shadow_style=”preset2″ global_colors_info=”{}”]<\/p>\n

1.<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

Press Ctrl + Home<\/strong> to move to cell A1 (the top left corner of your worksheet).
Your headings must be visible prior to moving to the next step.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,3_4″ _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”|700|||||||” text_text_color=”#00a4e4″ text_font_size=”31px” text_orientation=”center” text_text_shadow_style=”preset2″ global_colors_info=”{}”]<\/p>\n

2.<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_padding=”0px|||||” global_colors_info=”{}”]<\/p>\n

On the View<\/strong> tab, in the Window<\/strong> group, click Freeze Panes,<\/strong> Freeze First Column<\/strong>.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FreezePanes5.png” align=”center” _builder_version=”3.29.3″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

A line<\/strong> displays beside the First Column<\/strong> to indicate that it is frozen.<\/p>\n

In our example, the headings in column A remain frozen as you scroll right to view the data in columns C, D, and E.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FreezePanes11.png” align=”center” _builder_version=”3.29.3″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

Note:<\/strong> The Freeze First Column<\/strong> feature freezes the First Column that is displayed.<\/p>\n

For example, if Column J was the First Column displayed in your worksheet, Column J would be locked.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FreezePanes12.png” align=”center” _builder_version=”3.29.3″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.29.3″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

Recommendation:<\/strong> Press Ctrl + Home<\/strong> prior to using the Freeze First Column <\/strong>feature.<\/p>\n

Note:<\/strong> When you freeze a worksheet, it has no effect on how the worksheet is printed.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”3.29.3″ custom_margin=”0px||||false|false” custom_padding=”0px||||false|false” global_colors_info=”{}”][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

How to Freeze More than One Row or Column Heading:<\/h2>\n

[\/et_pb_text][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

Do you have more than one Row or Column that contains a Heading or Title?<\/p>\n

Or do you want both the Row and the Column Headings to be frozen at the same time?<\/p>\n

If yes, use Freeze Panes<\/strong>.<\/p>\n

To use the Freeze Panes feature, you must select an Anchor Cell.<\/strong><\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,3_4″ _builder_version=”3.29.3″ custom_margin=”0px||10px||false|false” custom_padding=”0px||0px||false|false” global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”3.29.3″ custom_padding=”|0px|||false|false” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ text_font=”|700|||||||” text_text_color=”#00a4e4″ text_font_size=”31px” text_orientation=”center” custom_margin=”0px||0px||false|false” custom_padding=”0px||0px||false|false” text_text_shadow_style=”preset2″ global_colors_info=”{}”]<\/p>\n

*<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”0px||0px||false|false” custom_padding=”0px||0px||false|false” global_colors_info=”{}”]<\/p>\n

All rows above<\/strong> the Anchor Cell<\/strong> will remain visible while scrolling.<\/span><\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,3_4″ _builder_version=”3.29.3″ custom_margin=”0px||10px||false|false” custom_padding=”0px||0px||false|false” global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”3.29.3″ custom_padding=”|0px|||false|false” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ text_font=”|700|||||||” text_text_color=”#00a4e4″ text_font_size=”31px” text_orientation=”center” custom_margin=”0px||0px||false|false” custom_padding=”0px||0px||false|false” text_text_shadow_style=”preset2″ global_colors_info=”{}”]<\/p>\n

*<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”0px||0px||false|false” custom_padding=”0px||0px||false|false” global_colors_info=”{}”]<\/p>\n

All columns to the left <\/strong>of the Anchor Cell<\/strong> will remain visible while scrolling.<\/span><\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

In our example, you may wish to lock the Months (in Row 2) and the Locations (in Column A). Therefore, as you Enter or Analyze the data, the Months and Locations remain visible if you scrolled down or to the right.<\/p>\n

In order to freeze these rows and column, the Anchor Cell must be Cell B3.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FreezePanes13.png” align=”center” _builder_version=”3.29.3″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,3_4″ _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”|700|||||||” text_text_color=”#00a4e4″ text_font_size=”31px” text_orientation=”center” text_text_shadow_style=”preset2″ global_colors_info=”{}”]<\/p>\n

1.<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

Go to the Anchor Cell<\/strong>.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

*<\/strong> All rows Above<\/strong> the Anchor Cell will be frozen.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

*<\/strong> All columns to the Left <\/strong>the Anchor Cell will be frozen.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,3_4″ _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”|700|||||||” text_text_color=”#00a4e4″ text_font_size=”31px” text_orientation=”center” text_text_shadow_style=”preset2″ global_colors_info=”{}”]<\/p>\n

2.<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_padding=”0px|||||” global_colors_info=”{}”]<\/p>\n

On the View<\/strong> tab, in the Window<\/strong> group, click Freeze Panes<\/strong>, Freeze Panes<\/strong>.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FreezePanes6.png” align=”center” _builder_version=”3.29.3″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

Now all rows above Row 2 are frozen and all columns to the left of Column B are frozen. As you Enter the Sales figures, both the Month and the Location remain visible.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

A line<\/strong> displays to indicate the frozen rows and columns.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FreezePanes14.png” align=”center” _builder_version=”3.29.3″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

Note:<\/strong> When you freeze a worksheet, it has no effect on how the worksheet is printed.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”3.29.3″ custom_margin=”0px||||false|false” custom_padding=”0px||20px||false|false” global_colors_info=”{}”][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

How to Modify Freeze Panes \/ Unlock the Row or Column (or Clear Freeze Panes):<\/h2>\n

[\/et_pb_text][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

Do you want to modify what Rows or Columns are frozen? If yes, use the Unfreeze Panes<\/strong> feature. Then use the Freeze Top Row, Freeze First Column, or Freeze Panes to lock the correct headings.<\/p>\n

Do you want to turn the Freeze Panes feature off? If yes, use Unfreeze Panes<\/strong>.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,3_4″ _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ text_font=”|700|||||||” text_text_color=”#00a4e4″ text_font_size=”31px” text_orientation=”center” text_text_shadow_style=”preset2″ global_colors_info=”{}”]<\/p>\n

1.<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_padding=”0px|||||” global_colors_info=”{}”]<\/p>\n

On the View<\/strong> tab, in the Window<\/strong> group, click Freeze Panes<\/strong>, Unfreeze Panes<\/strong>.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FreezePanes7.png” align=”center” _builder_version=”3.29.3″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.29.3″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

The Row or Column headings are no longer locked. As you move through your large spreadsheet, the headings disappear.<\/p>\n

Note:<\/strong> the UnFreeze Panes feature is only available if the one of the Freeze Panes options has been used on the worksheet.<\/p>\n

* Freeze Panes<\/p>\n

* Freeze Top Row<\/p>\n

* Freeze First Column\u00a0<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”3.29.3″ custom_margin=”0px||||false|false” custom_padding=”0px||20px||false|false” global_colors_info=”{}”][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

Tables and Freeze Panes<\/h2>\n

[\/et_pb_text][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

Note:<\/strong> If you have used the Format as Table<\/strong> feature, you may not need to use Freeze Panes. Excel automatically displays the column headings when you scroll down.<\/p>\n

However, if you want to lock specific columns and rows, use the Freeze Panes feature.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”3.29.3″ custom_margin=”0px||||false|false” custom_padding=”0px||||false|false” global_colors_info=”{}”][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

Freeze Panes – Keyboard Shortcut<\/h2>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.29.3″ custom_margin=”0px||||false|false” custom_padding=”0px||||false|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

In Excel, press and release the Alt<\/strong> key to display key tips for each tab in the Ribbon.<\/p>\n

Press the letter corresponding to the specific Ribbon tab to display the shortcut key for all of the commands on that tab.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”3.29.3″ global_colors_info=”{}”]<\/p>\n

Press Alt + W<\/strong>, F<\/strong>, and then press the specific letter to choose one of the Freeze Pane features.<\/p>\n

* F = Freeze Panes or Unfreeze Panes<\/p>\n

* R = Freeze Top Row<\/p>\n

* C = Freeze First Column<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FreezePanes15.png” align=”center” _builder_version=”3.29.3″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”3.29.3″ custom_margin=”0px||||false|false” custom_padding=”0px||||false|false” global_colors_info=”{}”][et_pb_row _builder_version=”3.29.3″ custom_margin=”0px||0px||false|false” custom_padding=”0px||0px||false|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.29.3″ custom_margin=”0px||0px” custom_padding=”0px||0px” global_colors_info=”{}”]<\/p>\n

Please share this with other Excel users and help them work with large spreadsheets.<\/p>\n

 <\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”3.27.4″ text_text_color=”#00a4e4″ text_font_size=”22px” text_orientation=”center” custom_margin=”0px||0px” custom_padding=”0px||0px” text_text_align=”center” global_colors_info=”{}”]<\/p>\n

~ Let Microsoft Excel do the work for you. ~<\/strong><\/em><\/p>\n

 <\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ admin_label=”Submit a Commet” _builder_version=”3.25.2″ custom_margin=”0px||” custom_padding=”0px|20px||20px” global_colors_info=”{}”][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_comments show_count=”off” _builder_version=”4.13.0″ form_field_background_color=”#ffffff” form_field_text_color=”#333333″ header_font=”Montserrat||||||||” body_font=”||||||||” form_field_font=”||||||||” form_field_text_align=”left” custom_button=”on” button_text_color=”#ffffff” button_bg_color=”#00A4E4″ button_border_color=”#00A4E4″ button_font=”Montserrat|600|||||||” button_icon=”E||divi||400″ button_icon_color=”#ffffff” button_alignment=”right” custom_margin=”0px||0px” custom_padding=”0px|0px|0px|0px” border_width_all_fields=”1px” border_color_all_fields=”#dbdbdb” border_style_all_fields=”ridge” box_shadow_style_fields=”preset3″ box_shadow_style_button=”preset2″ global_colors_info=”{}”][\/et_pb_comments][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

Do your Column or Row Headings disappear when you scroll in your Excel worksheet? As a spreadsheet grows in size, the headings disappear as you scroll down (or to the right). Discover how to keep your headings visible no matter where you are in your worksheet […]<\/p>\n","protected":false},"author":1,"featured_media":3267,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[2],"tags":[86,87,12,36,25,24,26,88,89,90,91,92,93,94,32,35,33,34,48,95,96,97,98,99,100],"class_list":["post-3140","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-excel","tag-column","tag-column-headings","tag-excel","tag-excel-2013","tag-excel-2016","tag-excel-2019","tag-excel-tips","tag-freeze-first-column","tag-freeze-pane","tag-freeze-panes","tag-freeze-top-row","tag-left-column","tag-lock-column","tag-lock-row","tag-microsoft-excel","tag-microsoft-excel-2013","tag-microsoft-excel-2016","tag-microsoft-excel-2019","tag-moving-around-excel","tag-row","tag-row-headings","tag-scrolling","tag-top-row","tag-unfreeze-panes","tag-visible"],"yoast_head":"\nKeep Row and Column Headings Visible in Excel - Brenda Penman<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.brendapenman.com\/blog\/excel_freeze_panes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Keep Row and Column Headings Visible in Excel - Brenda Penman\" \/>\n<meta property=\"og:description\" content=\"Do your Column or Row Headings disappear when you scroll in your Excel worksheet? As a spreadsheet grows in size, the headings disappear as you scroll down (or to the right). Discover how to keep your headings visible no matter where you are in your worksheet [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.brendapenman.com\/blog\/excel_freeze_panes\/\" \/>\n<meta property=\"og:site_name\" content=\"Brenda Penman\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-27T00:00:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-21T22:40:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FreezePanes0.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1080\" \/>\n\t<meta property=\"og:image:height\" content=\"717\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Brenda Penman\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Brenda Penman\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"20 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_freeze_panes\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_freeze_panes\\\/\"},\"author\":{\"name\":\"Brenda Penman\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#\\\/schema\\\/person\\\/1ac7a1b963fb0e6f6f2e518cce9721ef\"},\"headline\":\"Keep Row and Column Headings Visible in Excel\",\"datePublished\":\"2019-09-27T00:00:28+00:00\",\"dateModified\":\"2021-11-21T22:40:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_freeze_panes\\\/\"},\"wordCount\":3956,\"image\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_freeze_panes\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/FreezePanes0.png\",\"keywords\":[\"Column\",\"Column Headings\",\"Excel\",\"Excel 2013\",\"Excel 2016\",\"Excel 2019\",\"Excel Tips\",\"Freeze First Column\",\"Freeze Pane\",\"Freeze Panes\",\"Freeze Top Row\",\"Left Column\",\"Lock Column\",\"Lock Row\",\"Microsoft Excel\",\"Microsoft Excel 2013\",\"Microsoft Excel 2016\",\"Microsoft Excel 2019\",\"Moving around Excel\",\"Row\",\"Row Headings\",\"Scrolling\",\"Top Row\",\"Unfreeze Panes\",\"Visible\"],\"articleSection\":[\"Microsoft Excel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_freeze_panes\\\/\",\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_freeze_panes\\\/\",\"name\":\"Keep Row and Column Headings Visible in Excel - Brenda Penman\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_freeze_panes\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_freeze_panes\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/FreezePanes0.png\",\"datePublished\":\"2019-09-27T00:00:28+00:00\",\"dateModified\":\"2021-11-21T22:40:56+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#\\\/schema\\\/person\\\/1ac7a1b963fb0e6f6f2e518cce9721ef\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_freeze_panes\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_freeze_panes\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_freeze_panes\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/FreezePanes0.png\",\"contentUrl\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/FreezePanes0.png\",\"width\":1080,\"height\":717,\"caption\":\"Use Freeze Panes to Keep Row and Column Headings Visible in Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel_freeze_panes\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Keep Row and Column Headings Visible in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/\",\"name\":\"Brenda Penman\",\"description\":\"Learn Microsoft Office - Excel, Word, PowerPoint, Outlook, OneNote\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#\\\/schema\\\/person\\\/1ac7a1b963fb0e6f6f2e518cce9721ef\",\"name\":\"Brenda Penman\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g\",\"caption\":\"Brenda Penman\"},\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/author\\\/mfvwwyzbgoqzie\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Keep Row and Column Headings Visible in Excel - Brenda Penman","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.brendapenman.com\/blog\/excel_freeze_panes\/","og_locale":"en_US","og_type":"article","og_title":"Keep Row and Column Headings Visible in Excel - Brenda Penman","og_description":"Do your Column or Row Headings disappear when you scroll in your Excel worksheet? As a spreadsheet grows in size, the headings disappear as you scroll down (or to the right). Discover how to keep your headings visible no matter where you are in your worksheet [...]","og_url":"https:\/\/www.brendapenman.com\/blog\/excel_freeze_panes\/","og_site_name":"Brenda Penman","article_published_time":"2019-09-27T00:00:28+00:00","article_modified_time":"2021-11-21T22:40:56+00:00","og_image":[{"width":1080,"height":717,"url":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FreezePanes0.png","type":"image\/png"}],"author":"Brenda Penman","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Brenda Penman","Est. reading time":"20 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.brendapenman.com\/blog\/excel_freeze_panes\/#article","isPartOf":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_freeze_panes\/"},"author":{"name":"Brenda Penman","@id":"https:\/\/www.brendapenman.com\/blog\/#\/schema\/person\/1ac7a1b963fb0e6f6f2e518cce9721ef"},"headline":"Keep Row and Column Headings Visible in Excel","datePublished":"2019-09-27T00:00:28+00:00","dateModified":"2021-11-21T22:40:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_freeze_panes\/"},"wordCount":3956,"image":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_freeze_panes\/#primaryimage"},"thumbnailUrl":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FreezePanes0.png","keywords":["Column","Column Headings","Excel","Excel 2013","Excel 2016","Excel 2019","Excel Tips","Freeze First Column","Freeze Pane","Freeze Panes","Freeze Top Row","Left Column","Lock Column","Lock Row","Microsoft Excel","Microsoft Excel 2013","Microsoft Excel 2016","Microsoft Excel 2019","Moving around Excel","Row","Row Headings","Scrolling","Top Row","Unfreeze Panes","Visible"],"articleSection":["Microsoft Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.brendapenman.com\/blog\/excel_freeze_panes\/","url":"https:\/\/www.brendapenman.com\/blog\/excel_freeze_panes\/","name":"Keep Row and Column Headings Visible in Excel - Brenda Penman","isPartOf":{"@id":"https:\/\/www.brendapenman.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_freeze_panes\/#primaryimage"},"image":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_freeze_panes\/#primaryimage"},"thumbnailUrl":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FreezePanes0.png","datePublished":"2019-09-27T00:00:28+00:00","dateModified":"2021-11-21T22:40:56+00:00","author":{"@id":"https:\/\/www.brendapenman.com\/blog\/#\/schema\/person\/1ac7a1b963fb0e6f6f2e518cce9721ef"},"breadcrumb":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel_freeze_panes\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.brendapenman.com\/blog\/excel_freeze_panes\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.brendapenman.com\/blog\/excel_freeze_panes\/#primaryimage","url":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FreezePanes0.png","contentUrl":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FreezePanes0.png","width":1080,"height":717,"caption":"Use Freeze Panes to Keep Row and Column Headings Visible in Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.brendapenman.com\/blog\/excel_freeze_panes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.brendapenman.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Keep Row and Column Headings Visible in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.brendapenman.com\/blog\/#website","url":"https:\/\/www.brendapenman.com\/blog\/","name":"Brenda Penman","description":"Learn Microsoft Office - Excel, Word, PowerPoint, Outlook, OneNote","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.brendapenman.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.brendapenman.com\/blog\/#\/schema\/person\/1ac7a1b963fb0e6f6f2e518cce9721ef","name":"Brenda Penman","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g","caption":"Brenda Penman"},"url":"https:\/\/www.brendapenman.com\/blog\/author\/mfvwwyzbgoqzie\/"}]}},"_links":{"self":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts\/3140","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/comments?post=3140"}],"version-history":[{"count":5,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts\/3140\/revisions"}],"predecessor-version":[{"id":3504,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts\/3140\/revisions\/3504"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/media\/3267"}],"wp:attachment":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/media?parent=3140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/categories?post=3140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/tags?post=3140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}