Keep specific rows or columns visible as you scroll a spreadsheet

MS OFfice Web Components Spreadsheet

Keep specific rows or columns visible as you scroll a spreadsheet

  1. In the design window, make sure the spreadsheet is activated. For instructions, see Help for your design program.
  2. Select the row below the rows you want to keep visible as you scroll, or select a column to the right of the columns you want to keep visible.

    If you want to keep both specific rows and specific columns visible as you scroll, select one cell below and to the right of the rows and columns you want to keep visible.

  3. On the toolbar, click Commands and Options , and then click the Sheet tab.
  4. Click Freeze Panes.

Note   This setting cannot be changed in the browser.