Guidelines on Sheet Information

Consider the guidelines in this topic when using sheet information.

  • You can see separate Connection sections in the Sheet Info dialog box for each valid grid present on the sheet. For example, Connection (Grid 1), Connection (Grid 2), and so on.
  • In a multiple-grid sheet, if you rename a grid range or delete its original name using Google's Named Ranges, instead of Smart View's Rename Grid Range option, then Smart View considers such a grid as invalid. This is because the grid's connection is broken, thus preventing Smart View from identifying it. You cannot view details of such a grid in the Sheet Info dialog box and cannot perform any grid operations on such a grid.

    It is recommended to always use Smart View's Rename Grid Range option for giving friendly or understandable names to your grids. For more information, see Renaming Grid Ranges.

  • For a Function sheet, the Sheet Info dialog box only displays the Sheet Type as Function. No other description is available for display for a Function sheet.