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

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