In Excel 2010, the maximum worksheet size is 1,048,576 rows by 16,384 columns. In this article, find all workbook, worksheet, and feature specifications and limits.

The .xls file format has a limit of 65,536 rows in each sheet, while the .xlsx file format has a limit of 1,048,576 rows per sheet. For more info, see File formats that are supported in Excel and Excel …

The following table states the maximum limits of memory storage and file size for workbooks in Excel, and on different platforms. For tips on how to reduce model size, see Create a memory-efficient Data …

This article describes the formula syntax and usage of the MAX function, which returns the largest value in a set of values.

How to change the column width and row height, including how to use the AutoFit feature, in your Excel worksheet.

Power Query specifications and limits are different from Excel specifications and limits.

Use Sum and Max or Min to calculate the largest or smallest value in a range. For example, you can use it to find out who has the smallest error rate in a production run at a factory or the largest salary in …

An array formula (one that spans multiple cells) can do calculations on rows and columns of cells where you might otherwise need to use several formulas.

It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it …

The AGGREGATE function can apply different aggregate functions to a list or database with the option to ignore hidden rows and error values.