1. Here is the data of a cell, and several lines of the same data should be filled in.

2. Select the column cell that contains the current cell.

3. press Ctrl+? D shortcut key, see that the selected adjacent cell is filled with the same content as the starting cell.

4. The filled content is copied based on the top of the selected area, so you can only choose down and select the interval cell.

5. View the same and copy the same content into the selected cell.