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 …

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

A data model is embedded data inside an Excel workbook that powers data visualizations such as PivotTables, and Pivot Charts. This article documents the maximum and configurable limits for Excel …

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

Count the number of rows, columns, or cells in Excel by using the status bar at the bottom of the Excel screen. You can also customize the status bar.

Unlike other Microsoft 365 programs, Excel does not provide a button to number data automatically. However, you can easily add sequential numbers to rows of data by dragging the fill handle to fill a …

Excel provides multiple techniques that you can use to count cells, rows, or columns of data. To help you make the best choice, this article provides a comprehensive summary of methods, a …

The List View Threshold (LVT) limit is in place to help get consistent performance across all users with queries to the back-end database. Here's some information about the limits, how it all works, and …

The MAXIFS function returns the maximum value among cells specified by a given set of conditions or criteria: numbers, dates, text, etc. This feature is available on Windows or Mac if you have Office …