M
Mr. Low
Hi
I understand that the user could delete blank rows in a worksheet at one go
by going to F5 > Special > Select blank rows and press delete to remove it.
In the reverse, if I wish to insert empty rows at specific interval of 3 or
4 rows to a block of compact data (without any empty rows in beween), may I
know if there is any key board steps for this ?
At prersent I only can do it by assigning repeated even or odd number to the
block of cell and then do a sorting after replacing the missing even or odd
numbers.
Illustration
xxx xxx
xxx xxx
xxx xxx
xxx xxx
xxx xxx
xxx xxx
Thanks
Low
A36B58K641
I understand that the user could delete blank rows in a worksheet at one go
by going to F5 > Special > Select blank rows and press delete to remove it.
In the reverse, if I wish to insert empty rows at specific interval of 3 or
4 rows to a block of compact data (without any empty rows in beween), may I
know if there is any key board steps for this ?
At prersent I only can do it by assigning repeated even or odd number to the
block of cell and then do a sorting after replacing the missing even or odd
numbers.
Illustration
xxx xxx
xxx xxx
xxx xxx
xxx xxx
xxx xxx
xxx xxx
Thanks
Low
A36B58K641