Forum Discussion

kinanbshara's avatar
kinanbshara
Copper Contributor
Aug 17, 2023

find and replace empty cells on excel web for Microsoft 365 Basic license

Hello,

I tried to replace all empty cells with 0, no way to do that with the web version,

simple find and replace work correctly in desktop app but not in web version.

 

thanks

excel
Excel for web

3 Replies

Sort By
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Aug 17, 2023

    kinanbshara Do you have the Automate tab available in your Excel on-line? If so, you can use this Office script to achieve this:

    function main(workbook: ExcelScript.Workbook) {
    // Your code here
    let emptyAreas = workbook.getSelectedRange().getSpecialCells(ExcelScript.SpecialCellType.blanks);
  emptyAreas.getAreas().forEach(r => {
    r.setValue(0);
  });

}
      • JKPieterse's avatar
        JKPieterse
        Silver Contributor
        Aug 17, 2023
        In that case I'm afraid you are out of luck, there is no easy way to do this in Excel-online.

Resources