// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("B1").setFormula("=A1"); // config range B1's FormulaHidden property. worksheet.getRange("B1").setFormulaHidden(true); // protect worksheet, range B1's formula will not show in exported xlsx file. worksheet.setProtection(true); // Save to an excel file workbook.save("SetRangeFormulaHidden.xlsx");