Home  >  Article  >  Software Tutorial  >  How to fill upward in EXCEL2021 Operation method

How to fill upward in EXCEL2021 Operation method

WBOY
WBOYforward
2024-02-09 09:15:311352browse

php editor Xinyi will introduce to you in detail the operation method of upward filling in EXCEL2021. In EXCEL, fill up is a convenient operation that can quickly fill the data in the column. First, select the cells you want to fill upward, then hover your mouse over the lower right corner, and the cursor will turn into a black cross arrow. Then, hold down the left mouse button, drag upward, and release the mouse to complete the filling. In addition, you can also use the shortcut key Ctrl D to fill upward. Mastering these operating skills can improve work efficiency and quickly complete data filling tasks.

[Operation method]

1. Open the EXCEL2021 software and enter the following parameters.

EXCEL2021怎么向上填充 操作方法

2. Then select the cells below

EXCEL2021怎么向上填充 操作方法

3. Then click [Fill] settings, and then click [Up] setting.

EXCEL2021怎么向上填充 操作方法

#4. This completes the upward filling of the content.

EXCEL2021怎么向上填充 操作方法

The above is the detailed content of How to fill upward in EXCEL2021 Operation method. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:downxia.com. If there is any infringement, please contact admin@php.cn delete