This is a very simple query to anyone with more experience than me, I am sure!
I have created a simple spreadsheet which contains a column for a running total. I have entered a formula and used the fill down option so that my boss can just fill in the blanks and the total will appear in the running total column, but this means that the last value for the running total then continues to display down the page even when the other values have not yet been entered. It's a presentation thing as much as anything, but is there any way to hide the values in the running total column (in this case column F) until the cells to which the formula relates (in this case column E) contain data?
I've tried to be concise - hope this makes sense! I'd be very grateful if anyone can help me with this. Thanks