Entering data using Fill Options in Excel

Buzz

Ngày cập nhật gần nhất: 15/4/2026

When dealing with a large amount of data while working on Excel spreadsheets, you often need to create data of the same type following a specific pattern. This tutorial will show you how to enter data using Fill Options in Excel after entering sufficient descriptions of the data patterns.

Basic features in Excel can greatly save users time and effort compared to manual calculations. This includes the ability to generate a series of data of the same type and pattern from initial basic data. This will be extremely helpful for your work.

Guide to entering data using Fill Options in Excel spreadsheets

Step 1: Input the data into the excel cells according to a specific rule and then select those cells. For example, here I want to create 12 excel cells, each containing Month 1, Month 2, ..., Month 12. To do this, you hover your mouse over the bottom edge of the selected area until the cursor appears as shown in the image:

Step 2: Hold down the left mouse button and drag the cursor down to the cell containing Month 12 as shown in the image, then release the mouse button:

Excel will automatically generate the next excel cells, with 3 cells initially containing Months 1, 2, 3 up to Month 12:

Similarly, you perform the above steps to create the next days starting from 3 days Monday, Tuesday, Wednesday as shown in the image below:

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]