Need Excel Help - Blank Formulas

crs.one

macrumors member
Original poster
Jan 8, 2012
71
0
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
 

turtle777

macrumors 6502a
Apr 30, 2004
681
15
Sure, if I understand right, this can be easily done.

You want a formula (for example) in cell C1, C3, C5, C7 etc.
Cells C2, C4, C6 etc. should be empty, right ?

Enter the formula in cell C1, and make sure cell C2 is empty.
Then select BOTH cells, and click on the little blue box in the lower right corner of that selection, then drag the mouse down to copy the cell.

-t
 

GGJstudios

macrumors Westmere
May 16, 2008
44,419
759
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
Excel > Preferences > View > Window options > Show zero values (uncheck)
 

crs.one

macrumors member
Original poster
Jan 8, 2012
71
0
Excel > Preferences > View > Window options > Show zero values (uncheck)
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
Chris
 

exegete77

macrumors 6502a
Feb 12, 2008
529
5
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
Chris
There is, sort of. It basically consists of changing the row height of row in which the cell is located.

Unfortunately my Excel guru days ended four years ago, and I don’t even own Excel now. You can set up styles for cells so that the consistency would be there and you could adjust just the style instead of individual cells.
 
Last edited: