You can apply the formatting of the cell that you zoom in on to the cells that are created by zooming. For Smart View formatting, this ability applies to data cells. For Excel formatting, this ability applies to member cells.
To apply Excel formatting selections to member cells created by zooming, from the Smart View ribbon, select Options. Then select all these options:
From the Formatting page, select Use Excel Formatting
From the Member Options page, select Preserve Formulas and Comments in ad hoc operations (except Pivot)
From the Member Options page, select Formula Fill