Excel Column And Rows Limits

   How Many Column and Rows You Can Make in Microsoft Excel

How many column and rows can be an Excel sheet it depends on which version of Microsoft Office / excel you are using. Those who are using old Microsoft office / excel version from decade. 

They may come to worry about it. Because in excel 95 version maximum number of rows are 16348 and 256 column can be made. The number of rows was increase to (65536) in excel version 97. 

But the number of columns is still 256. The limits remain in the excel version 2003.

Then the limits of rows in columns and rows were increase in Microsoft office 2007. The maximum number of rows can be more then million (1048676) and the maximum column number is 16384 from excel 2007 to excel 2013. 

The user of excel new version usually do not face the rows and columns limitations. It does happen occasionally that any excel sheet need more than 16000 columns or more than one million rows.  For such a huge data excel may not be appropriate software.

Excel spreadsheet or workbook has limited worksheet. But the limit is directly connected to available computer memory.  If memory could not open four or five worksheets than the range of 256 worksheets may be an effective. 

There is no limit on the number of excel worksheets in excel version 2013. But it depends on RAM in the computer.

The latest addition is excel 2016. Excel 2016 file format isn’t changed. So that the same number of rows (1048676) and column (65536) still applies.

Specification and Limits of Workbook and Worksheet

Feature	Maximum limit
Open workbooks	Limited by available memory and system resources
Worksheet size	1,048,576 rows by 16,384 columns
Column width	255 characters
Row height	409 points
Page breaks	1,026 horizontal and vertical
Total number of characters a cell can contain	32,767 characters
Characters in a header or footer	255
Sheets in a workbook	Limited by available memory (default is 1 sheet)
Colors in a workbook	16 million colors (32 bit with full access to 24 bit color spectrum)
Named views in a workbook	Limited by available memory
Unique cell formats/cell styles	64,000
Fill styles	256
Line weight and styles	256
Unique font types	1,024 global fonts available for use; 512 per workbook
Number formats in a workbook	Between 200 and 250, depending on the language version of Excel that you have installed
Names in a workbook	Limited by available memory
Windows in a workbook	Limited by available memory
Hyperlinks in a worksheet	66,530 hyperlinks
Panes in a window	4
Linked sheets	Limited by available memory
Scenarios	Limited by available memory; a summary report shows only the first 251 scenarios
Changing cells in a scenario	32
Adjustable cells in Solver	200
Custom functions	Limited by available memory
Zoom range	10 percent to 400 percent
Reports	Limited by available memory
Sort references	64 in a single sort; unlimited when using sequential sorts
Undo levels	100
Fields in a data form	32
Workbook parameters	255 parameters per workbook
Items displayed in filter drop-down lists	10,000
Noncontiguous cells that can be selected	2,147,483,648 cells

SHARE

Milan Tomic

Hi. I’m Designer of Blog Magic. I’m CEO/Founder of ThemeXpose. I’m Creative Art Director, Web Designer, UI/UX Designer, Interaction Designer, Industrial Designer, Web Developer, Business Enthusiast, StartUp Enthusiast, Speaker, Writer and Photographer. Inspired to make things looks better.

• 
• 
• 
•