WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

Quick Tip: How to Use Autofill in Excel

July 26, 2022
7.1K Views

Discover the power of Excel autofill in this concise guide. Explore its potential to streamline data entry and maintain consistency. Uncover common conflicts and learn how to overcome them. Gain practical insights through step-by-step instructions. Maximize productivity and accuracy in Excel with effective autofill techniques.

How to Use Autofill in Excel Online, 2016 and 2019:

To automatically fill a set of cells in Excel, use AutoFill. Numerous simple to follow AutoFill examples may be found on this page. There are no boundaries!

1.For instance, enter the numbers 10 in cell A1 and 20 in cell A2.

2.Drag the fill handle downward while selecting cells A1 and A2. The small green box in the lower right corner of a selected cell or range of selected cells is the fill handle.

Note: Based on the pattern of the first two numbers, AutoFill automatically fills in the numbers.Jan should go in cell A1.

3.Drag the fill handle downward while selecting cell A1. The month names are automatically filled in using AutoFill.

4.Cell A1 should contain Product 1.

5.Drag the fill handle downward while selecting cell A1. The product names are automatically filled in by AutoFill.

6.Fill out Friday in cell A1.

7.Drag the fill handle downward while selecting cell A1. The day names are automatically filled in using AutoFill.

8.Date 1/14/2019 should be entered into cell A1.

9.Drag the fill handle downward while selecting cell A1. The days are automatically filled up by AutoFill.

10.Use the AutoFill settings to fill in weeks (skipping weekends), months (see the example below), or years instead of days.

11.Please take note of the alternatives to fill a series without formatting and to fill a series with simply the formatting.Cells A1 and A2 should be filled out with the dates 1/14/2019 and 1/21/2019, respectively.

12.Drag the fill handle downward while selecting cells A1 and A2. Based on the pattern of the first two dates, AutoFill automatically fills in the dates.

13.6:00 AM should be entered into cell A1.

14.Drag the fill handle across while selecting cell A1. The times are automatically filled up by AutoFill.

15.Simply create a custom list when Excel is unable to recognise the list.

16.In Excel, use flash fill to automatically extract or merge data.

17.The SEQUENCE function can also be used to fill a succession of cells. This feature is quite awesome.Using the SEQUENCE function, a two-dimensional array is produced. Start = 0; Step = 5; Rows = 7; Columns: 4.

18.Using the SEQUENCE function, an array of odd numbers is produced. 10 rows, 1 column, 1 step, and 1 start.

Note: This above written article is an attempt to show you how to use autofill in excel online, 2016 and 2019, in both windows and mac.You just need to have a little understanding of how and which way things work and you are good to go. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.

Trustpilot

stars

4.8
WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User

avator

Algirdas Jasaitis

FAQs

How do I enable Autofill in Excel?

Step 1 To begin, open Excel and navigate to the Options option at the bottom of the screen.

Select Option

Step 2 Now, go to the Editing options area by selecting Advanced. Check the box next to Enable fill handle and cell drag-and-drop and then click OK.

Click Ok

Can I undo or revert Autofill changes?

Yes, you can undo or revert Autofill changes in Excel. Here's how:

  • Immediately after autofilling, you can press Ctrl+Z on your keyboard or click the Undo button in the toolbar to undo the Autofill action and revert the changes.

  • If you have already performed other actions or closed the workbook, you can use the Ctrl+Z shortcut or click the Undo button repeatedly to step back through the history of changes until you reach the point where the Autofill was applied.

  • Another option is to manually delete or overwrite the autofilled data. Simply select the cells containing the autofilled data, press the Delete key on your keyboard, and enter the desired values or formulas manually.

By using these methods, you can easily undo or revert any unwanted or incorrect Autofill changes in Excel.

What are the limitations of Autofill in Excel?

Excel generates a list of probable entries based on the column containing the active cell. The entries are not finished if they are repeated within a row rather than a column. Excel solely completes text entries. Entries containing merely numbers, dates, and times are not finished.

Summary

With these techniques, WPS Spreadsheet users can enhance their productivity and accuracy in data management tasks. Whether it's autofilling numbers, dates, times, custom lists, or utilizing advanced features, this guide has equipped readers with the necessary knowledge to make the most of Autofill in WPS Spreadsheet, optimizing their workflow and achieving efficient data management.


15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.