How to automatically copy the previous row in excel

The method for excel to automatically copy the previous row is:

You can refer to the following method to complete:

Select column A ( Or select the first data to the last data row)-----press the F5 function key-----positioning condition----null value----confirm-----then write the equal sign (=)----Press the up direction key----Finally press CTRL and press Enter.

As shown in the picture:

1) Then select column A-----press the F5 function key

2) Positioning conditions----null value--- -Confirm

3) Then write the equal sign (=)----Press the arrow key up

4)Finally press CTRL and press Enter

Recommended tutorial: "excel tutorial"

The above is the detailed content of How to automatically copy the previous row in excel. For more information, please follow other related articles on the PHP Chinese website!