WPS Office Academy teaches strategies for free.Thanks for the help. WPS Office Spreadsheet not only covers all of the basic functions of Excel, but also enables advanced techniques for data cleaning and analyzing.
Relative reference, absolute reference, and mixed reference | WPS Academy Free Office Courses To master more operations about references in Excel, you can visit WPS Academy. Then, update the references in cell D2 and press Ctrl+Shift+Enter. To expand the range to which the existing array formula is applied, select all cells containing the formula and the empty cells you want to add, and press F2 to switch to the edit mode. If you try to delete the content of one individual cell, the system will warn that Part of an array cannot be changed.Ģ. To shrink the array formula, in other words, to apply the array formula to fewer cells, we need to delete the current array formula and enter a new one. L Steps to shrink and expand an array formula in WPS Office Excel.ġ. Thus, the formula is enclosed between the curly braces, and we can get the total sales easily. Then, press the 3 keys Ctrl+Shift+Enter on the keyboard. Select the range D2:D8, and enter the formula =B2:B8*C2:C8. To be less abstract, let's have a try now!ġ. O Apply a multi-cell array formula in WPS SpreadsheetĪ multi-cell array formula can return the results in multiple cells at a time. L Steps to edit an array formula in WPS Office Excel. There is no doubt that this operation is relatively convenient in this example however, if there are hundreds of rows in the table to calculate, this method may be annoying and time-wasting.Īt this time, we can apply a multi-cell array formula in this table. Drag the fill handle(+) to run the auto fill function.
Assume that we need to calculate the sales of each product, and we may perform like this without an array formula.ġ.Enter the formula =B2*C2 (Sales=Amount*Price) in the cell D2.Ģ. In this table below, the data of products amount, and price is given.
To explain more clearly, let's take an example. Unlike a regular formula, an array formula can process several values and perform multiple calculations within a selected range at a time. l What is an array formula in WPS Spreadsheet Excel? In this free tutorial, you will know what an array formula in Excel is and how to edit an array formula in WPS Office Excel.
0 kommentar(er)
