Use the right-click menu to clear all data in a worksheet About this taskYou can use the right-click menu in Planning Analytics for Microsoft Excel to clear all data in your worksheet. ProcedureRight-click any cell in the worksheet you want to clear data from. Click IBM® Planning Analytics. Click Clear data. Click Clear worksheet.