Home > Topics > excel > body text

How to divide in excel

coldplay.xixi
Release: 2023-01-13 00:41:58
Original
125744 people have browsed it

Excel division operation method: first open the table and create a new worksheet; then edit the numbers, select the cell in column C and enter the formula [=B1/A1] in the edit bar; finally press [ctrl and enter Key] to fill in the cells in column C to complete.

How to divide in excel

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2018 version, Dell G3 computer.

Excel division operation method:

1. Open the computer, find and double-click the excel2018 version to create a new worksheet;

How to divide in excel

2. After clicking to open a new excel worksheet, for the purpose of demonstration, edit the total number in column A and the quantity in column B;

How to divide in excel

3. After editing the numbers, select Cell in column C and enter the formula =B1/A1 in the edit bar;

How to divide in excel

#4. After entering the formula, press "ctrl and enter" at the same time. Fill the cells in column C to complete.

How to divide in excel

Related learning recommendations: excel tutorial

The above is the detailed content of How to divide in excel. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template