Excel query

Log in to reply
H

Hayles

  • #1
    How do I hide a value in a cell until it's relevant?

    I'm setting up a very simple spreadsheet for monthly credit card payments. As I copy each cell's formula down the sheet so it's ready for the next 12 months, (balance plus interest and purchases less payments, etc.) it carries forward the value right down the sheet for all the next 12 months. I know it doesn't matter but it looks messy.

    Not sure if that explained it very well?!

    How do I keep it blank until I get to the month in question?

    Many thanks
    Hayles
     
    Alpha

    Alpha

    Free Member
    Feb 16, 2004
    3,192
    474
    64
    West Midlands
  • #2
    Not sure if I have envisaged your spreadsheet correctly but you can hide rows by putting your cursor on the numbered border, click the left mouse button and hold down while you drag the cursor over the row numbers that you wish to hide (When you release the mouse button they should be highlighted).

    Then right click the mouse button which should bring up a menu.

    Select hide. This will hide the rows.

    To unhide the rows follow as above but highlight the row numbers either side of the hidden range.

    Right click and select unhide.

    If this is not the solution I'll try again :D
     
    Upvote 0
    H

    Hayles

  • #3
    Thanks Alan

    I haven't explained it well!

    I'm fine with the months showing, I just don't want any values showing in the months until I get to them.

    I need a formula to say something like : this cell is to show 0 until cell x has a value entered into it
     
    Upvote 0
    H

    Hayles

  • #8
    Thanks Noo Noo!

    Problem solved (as usual) by Alpha.

    He's a star and I'm going to bless him with our end of year accounts work.... oh he'll be soo pleased. :lol: :lol: :lol:

    (So don't be surprised if he changes his phone number or disappears!!)

    Hayles
     
    Upvote 0
    Log in to reply

    Latest Articles

    Top Bottom
    Community
    Articles
    Menu