Show only part of a spreadsheet

MS OFfice Web Components Spreadsheet

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 , 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.