Show only part of a spreadsheet

Office Web Components

Show only part of a spreadsheet

  1. In the design window, make sure the spreadsheet is activated. For instructions, see Help for your design program.
  2. On the toolbar, click Commands and Options Button image, and then click the Sheet tab.
  3. In the Viewable range box, type the range to display.

    For example, to display rows 1 through 15, type 1:15. To display columns A through F, type A:F. To display cells A1 through B20, type A1:B20.

Note  This setting cannot be changed in the browser.