Adding empty rows

How to add an empty row after each row of data in a table? This procedure is often necessary so that we can comment on reports that need to be printed. It can be achieved in several ways and one of the simplest is by usint the Sort option. In this text, you will learn how to perform this action.

The first thing to do is to add a column with ordinal numbers. In this example, we’ll add it to the right of the data table. In cell F3, it is sufficient to enter the number one, and then by double-clicking on the square in the lower right corner of the cursor marker of the selected cell, fill in the data series.

Next, it is necessary to select all ordinal numbers, then copy them to the Clipboard and paste them below the selection.

The next step is to select the table and rows and cells with additional values. You need to run the Sort option and then choose to sort by the contents of column F in ascending order.

Further, it is necessary to delete the contents of column F and format the table, and as a result we will get one where each subsequent row is empty.