Setup Menus in Admin Panel

Woodthorpe IT Solutions Ltd

Setup Menus in Admin Panel

Setup Menus in Admin Panel

Hiding zeros in Excel

Sometimes you don’t want to see the zeros in your spread sheet. Please see below how to hide them in your file.

In Excel 2010, choose File | Options | Advanced (Alt F T A) and remove the check next to Show a zero in cells that have zero value.

In Excel 2007, choose Office button | Options | Advanced (Alt F I A) and in the Display options, remove the check next to Show a zero in cells that have zero value.

In Excel XP (2002)/2003, choose Tools | Options (Alt T O). On the View tab, in the Window options section, remove the check next to Zero values.

19th September 2014

0 Responses on Hiding zeros in Excel"

Leave a Message

© Woodthorpe IT Solutions Business vector designed by Freepik
All prices on this site are excluding VAT unless otherwise stated.