Add
alternate empty rows to a range – the coolest method
Suppose you have a range of consecutive data in
column A and you want to add alternate empty rows between the range's cells.
How can this be done in the shortest, most elegant
way?
Well, there are several methods to accomplish
this task.
For example, here:
https://www.myofficetricks.com/how-to-insert-alternate-blank-rows-in-excel-spreadsheet/
Or here:
https://www.extendoffice.com/documents/excel/3727-excel-paste-in-alternate-rows.html
But they are all time-consuming because they
demand several steps.
Here's the coolest method, that uses only one
formula:
אין תגובות:
הוסף רשומת תגובה