Home >Topics >excel >How to switch between sequential filling and copy filling

How to switch between sequential filling and copy filling

藏色散人
藏色散人Original
2020-04-20 09:09:584839browse

How to switch between sequential filling and copy filling

#How to switch between sequential filling and copy filling?

In the Excel table:

Move the mouse to the lower right corner of the cell you want to copy and fill. When the mouse icon changes to " ", hold down the left button and drag it to the location you want. All the filled cells are surrounded by dotted circles, then release the left mouse button. At this time, there will be something like a paste icon next to the cell. Click the small drop-down triangle next to the icon, and you will be allowed to select. Copy filling is still filling sequentially.

The simpler method is that if you want to fill in order, you can hold down the Ctrl key and drag the mouse to fill in order.

Recommended: "Excel Tutorial"

The above is the detailed content of How to switch between sequential filling and copy filling. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn