Cell range fill Handle

Source: Internet
Author: User

Excel cell fills us in the previous case, small series for everyone briefly introduced, how to use the left mouse button to drag cell fill. In fact, using the Excel cell range fill handle is more flexible.

Enter data in a cell, holding down the right mouse button and dragging the fill handle along the direction you want to fill the sequence, you will receive a menu that contains the following items: Copy cells, fill them in a sequence, fill them in a format, fill them with a value, fill them with days, fill them with a weekday, refill them with a month, At this point, you can choose a way to fill as needed.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.