Detailed method to add auto-fill formula setting in excel2016

php editor Zimo teaches you how to use excel2016 to set and add automatic filling formulas in detail. The Excel auto-fill function can greatly improve work efficiency and make data processing more convenient and faster. By correctly setting formulas and filling options, various needs such as data increment, decrement, and jump can be easily realized. Next, let’s learn how to use the autofill function to set and add formulas in Excel 2016!

1. First open a new excel2016.

2. Select the file button.

3. Find the option selection card in the file.

4. Find the Advanced button and enter the advanced options.

5. Find [Extended Data Area Format and Formulas] on the right and check it.

6. Add new data in the last row of the worksheet. When cell e8 of the row is selected, excel will expand the formula of the previous row to the cell.

The above is the detailed content of Detailed method to add auto-fill formula setting in excel2016. For more information, please follow other related articles on the PHP Chinese website!