The operation of other versions is basically the same.

① Click "File"

② Click "Options" on the switched screen.

(3) Click "Advanced" to see if "Show zeros in zero value cells" is selected.

If not, please check and click "Save". Displays zeros in the file.