Need Excel Help - Blank Formulas

Discussion in 'Mac Apps and Mac App Store' started by crs.one, Jan 8, 2012.

Most Liked Posts
  1. crs.one, Jan 8, 2012

    crs.one macrumors member

    Joined:
    Jan 8, 2012
    #1
    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
     
    share
    + Quote Reply
  2. turtle777, Jan 8, 2012

    turtle777 macrumors 6502a

    Joined:
    Apr 30, 2004
    #2
    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
     
    share
    + Quote Reply
  3. GGJstudios, Jan 8, 2012

    GGJstudios macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #3
    Excel > Preferences > View > Window options > Show zero values (uncheck)
     
    share
    + Quote Reply
  4. turtle777, Jan 8, 2012

    turtle777 macrumors 6502a

    Joined:
    Apr 30, 2004
    #4
    LOL, that's another option. My Excel mind is too complicated.

    :)

    -t
     
    share
    + Quote Reply
  5. crs.one, Jan 9, 2012

    crs.one thread starter macrumors member

    Joined:
    Jan 8, 2012
    #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
     
    share
    + Quote Reply
  6. GGJstudios, Jan 9, 2012

    GGJstudios macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #6
    Sorry, no, I've never used Numbers. Excel does everything I need.
     
    share
    + Quote Reply
  7. crs.one, Jan 9, 2012

    crs.one thread starter macrumors member

    Joined:
    Jan 8, 2012
    #7
    Fair play. I wasn't sure if Excel was capable of adjusting the space between lines and paragraphs and such.

    Thanks
    Chris
     
    share
    + Quote Reply
  8. exegete77, Jan 10, 2012
    Last edited: Jan 10, 2012

    exegete77 macrumors 6502a

    Joined:
    Feb 12, 2008
    #8
    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.
     
    share
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page