2. Select the cell entered in the formula, press the Ctrl key to copy, and paste the Ctrl key into the adjacent cell.
3. Or select a cell with a formula and drag it down to copy the formula.
Extended data:
Use:
1, table processing
An outstanding feature of Excel is to manage data in tabular form. All data and information are managed in the form of two-dimensional tables (worksheets), and the relationship between data in cells is clear at a glance.
Make data processing and management more intuitive, convenient and easy to understand. For common table processing operations in daily work, such as adding rows, deleting columns, merging cells, table transposition, etc., in Excel, all operations can be simply completed through menus or tool buttons.
2. Data analysis
Excel not only can handle various forms conveniently, but also has powerful data processing and data analysis functions that ordinary spreadsheet software does not have.
It provides hundreds of built-in functions in nine categories, such as finance, date and time, mathematics and trigonometric functions, statistics, search and reference, database, text, logic and information, which can meet the needs of data processing and analysis in many fields.
3, chart making
Charts are the best way to submit data processing results. Many characteristics of data can be displayed intuitively through charts, such as the maximum value, minimum value, development trend, concentration degree and dispersion degree of data, which can be directly reflected in charts. Excel has powerful chart processing function.