Home / Tech Trends

Quickly populate based on the previous line

time:2025-01-07 15:02:38 Tech Trends

Excel quickly fills in the previous row

1. Left-click "C1 Cell" and press "Ctrl+C" to copy the content, left-click "C2 Cell" and press "Ctrl+V" to paste the content.

2. Move the mouse to the lower right corner of "C1 cell", wait for the cursor to change to the "cross" icon, and drag the mouse down to quickly fill in the table.

3. Hold down "Ctrl", left-click and select several "cells" that need to be filled with the same content, enter the filled content, and press "Ctrl+enter" at the same time.

 Drag the mouse down to quickly fill in the table.

《Quickly populate based on the previous line》 This does not represent the views of this website. If there is any infringement, please contact us to delete it.

Ranking

Digital Insights