Hi,
If you don't have information in the entire row, highlight one column,
filter it, then unselect the box that said 0 and you will have only rows with
information being shown
If this was helpful please click yes, thanks

"Ivan Koh" wrote:

Hi all,

Is there a function that i could use to compress empty blanks together?

For example if rows 2, 5, 10 have entries, could i collapse row 2 to row 1,
row 5 to 2 and row 10 to 3?

Also is there a way that i could lock information to prevent editing to it
unless it's from the main worksheet?

I.e to say that information from cell A of worksheet A is pulled to cell A
of worksheet B. Information from cell A of worksheet B can't be edited but
cell B of worksheet B can be edited.

Cos currently i realise that if i were to edit information in a cell that
had information pulled over from cell a of worksheet a, it would cause the
information to disappear.

Also does this function contradict with my previous request to collapse the
cells together?

Thanks

Ivan