It's surprising that Excel doesn't have a direct command for hiding data in visible cells, as this functionality ... Also, if you double-click the Format Painter icon, you can apply the formatting ...