Excel Ctrl Shift-Enter Command

Ctrl Shift-Enter helps convert the data into an array format consisting of multiple data values in Excel. It also supports differentiation between the regular formula & array formula in excelArray Formula In ExcelArray formulas are extremely helpful and powerful formulas that are used in Excel khổng lồ execute some of the most complex calculations. There are two types of array formulas: one that returns a single result and the other that returns multiple results.read more. Using this shortcut provides two major advantages: dealing with a set of values and returning the multiple values simultaneously.

Bạn đang xem: Video: array formulas

For example, we can calculate the sales và costs of various electronic gadgets over any given number of years.

Ctrl+Shift+Enter is one of the shortcuts used in Excel lớn perform the calculations with array formulas. It supports performing complex calculations using the standard excel functionsExcel FunctionsExcel functions help the users khổng lồ save time and maintain extensive worksheets.

Xem thêm: Quảng Cáo Sài Gòn Xưa ! - Những Kiểu Quảng Cáo Thời Sài Gòn Xưa

There are 100+ excel functions categorized as financial, logical, text, date & time, Lookup & Reference, Math, Statistical and Information functions.read more. It is widely used in the array formulae to apply functions and formulas khổng lồ a data set.


Explanation

Before we want khổng lồ use the shortcut CTRL+SHIFT+ENTER, we need to lớn understand more about the arrays. The array is the collection of the data, including text and numerical values in multiple rows và columns or only in a single row & column. For example, Array = 15, 25, -10, 24To enter the above values into an array, we need to lớn enter CTRL+SHIFT+ENTER after selecting the range of cells. It results in the array as:Array= = 15, 25, -10, 24
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*

Bài viết liên quan