Clearing all data in a worksheet

You can clear all data in a specific worksheet in IBM® Planning Analytics for Microsoft Excel.

When you clear data, the cleared cells remain as blank cells on the worksheet. Formats, such as number formats, conditional formats, and borders are retained. Clearing the content does not break the link to the datasource.

You can clear data in a worksheet either by using the IBM Planning Analytics ribbon or the right-click menu.