Excel > Preferences > View > Window options > Show zero values (uncheck)I want to set a column with the same formula. However, the formula only appears on every other row. I am wondering if I can make the alternating rows appear blank instead of reading "0." Is this possible?
Excel for Mac 2011
Brilliant, thank you so much.Excel > Preferences > View > Window options > Show zero values (uncheck)
There is, sort of. It basically consists of changing the row height of row in which the cell is located.Brilliant, thank you so much.
If I may impose on your time again...
Are you familiar with Numbers? In the Inspector, under the Text tab, one can alter the spacing for line, before paragraph, after paragraph, etc.
I haven't been able to find a comparable setting in Excel to tweak the space between each line. Is there one?
Again, many thanks