Excel Functionality

Excel Functionality with Smart View Forms

  • Data in addition to the form: You can enter data in rows below the form, columns to the right of the form, or additional tabs in the file. You may want to add comments to the right of the form to explain your planning assumptions to people that will review your plans before you submit them
  • Hide/unhide rows or columns functionality is available via the drop-down on the Format button on the Home ribbon
  • Freezing and unfreezing rows and columns functionality is available from the Freeze Panes button on the View ribbon
  • Sorting is not available in Smart View Planning