In the CalPlan form Update Data CalPlan, is there a way I can remove all of the rows with no data or zeros?

You can apply a filter in the Update Data in Form to hide rows with no data, with zeros, or both.

Right-click on the first column and select Filter and then select one of the three options:

  • Hide rows with no data
  • Hide rows with zeros
  • Hide rows with zeros and no data

Filter rows in Update Data in Form

To unhide the rows, from the row label, right-click and select Filter / Show rows with zeros and no data.