Office2007 is a commonly used office software for us. I think some friends still don’t know about office2007. How to use the maximum value of the Excel function? So today I will introduce to you how to use the maximum value of the office 2007 Excel function.

The first step is to open office2007 Excel, and then enter the data in the document as shown in the figure;

The second step is to select the cells after the value 90;

The third step is to click the subscript arrow under AutoSum, and then select the maximum value, as shown in the figure;

The fourth step is to press the Enter key to find the maximum value in this column.

The fifth step is to select automatic summation and click on the maximum value;

The sixth step, press the Enter key (Enter key), the pop-up interface is as shown in the picture; then select the 22 cell, hold down the left button without releasing it, and select the last 90 cell, as shown in the picture;

The seventh step is to hold down the Ctrl key and click on the 33 and 22 cells next to it, as shown in the figure;

The eighth step is to press the Enter key (Enter key) to find out which value is the maximum among the values ​​in multiple columns.

The above is the editor’s introduction to the use of the maximum value function in office 2007 Excel. Friends who don’t know how to use it should come and take a look.