יום שבת, 13 באוגוסט 2022

Add alternate empty rows to a range – the coolest method



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:

 

 











 

  

אין תגובות:

הוסף רשומת תגובה