Excel prints blank formula :(

[Dangerous]

Hi,

I have an Excel sheet with a simple formula in one of the columns. The formula picks up data from another sheet, but where this is no data it simply returns "" (nothing)

The problem is, these 'blank' cells still insist on printing, so I have a couple of blank pages after the actual printed data. I don't want to simply clear the cells because this sheet will change as data is added to the source data sheet.

Hope somebody know a neat trick!

Thanks,
DDDdddd

[Paul Komski]

Not quite sure what you are experiencing (a screen shot might help to understand) but you can always hide a group of rows and/or columns by just dragging the right border of a column to the left or the bottom border of a row upwards.

Highlight the relevant area or the whole sheet and choose Format Column/Row and choose unhide to bring them back into view. You highlight the whole sheet by putting the cursor on the little square at the column row junction top-left.

[Dangerous]

Hiya Paul,

Thanks for the reply... I'll post a screenshot and explain what I mean in a bit more detail on Monday!

Thanks,
David