If double clicking for ad hoc operations is enabled, you can zoom in to the default zoom level and zoom out by double clicking in a member cell.
To enable double clicking for zooming:
From the Smart View ribbon, select Options, and then select Advanced in the left panel.
Under Mode, select Double click for Operations.
If you do not select Double click for Operations, then double-clicking retains Excel functionality and puts the cell into edit mode.
Note:
In blank worksheets, double-clicking the first time retrieves the default grid and thereafter zooms in or out.
Related topics: