当前位置：网站首页>How to automatically fill down an excel table without dragging the mouse down

How to automatically fill down an excel table without dragging the mouse down

2022-08-09 05:53:00 【Teng Qingshan YYDS】

1. Open the EXCEL sheet that needs to be operated, enter the correct formula in the first cell and press Enter to get the result.

insert image description here
2. Select the cell containing the formula and below itFor the range of cells to be filled, press the "Ctrl" and letter "D" keys of the keyboard at the same time to fill the formula in the cells below.

Insert picture description here
3. Return to EXCEL table and find that the keyboard operation was successfulLet Excel spreadsheet formulas auto-fill.

insert image description here

Reprint:
How to fill an excel sheet automatically without dragging down with the mouse - Baidu Experience

a>

原网站

版权声明
本文为[Teng Qingshan YYDS]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/221/202208090552439798.html

边栏推荐

猜你喜欢

随机推荐