Register now or log in to join your professional community.
1,048,576 Rows denoted in excel sheet as same and 16,384 Columns denoted in excel sheet as XFD That’s a composition of one Microsoft Excel sheet
it depends on your monitor resolution
There is no maximum number limit however, if any, there should be 10 lac rows and 16k columns.
by copying the column and paste as transpose
More than you need and more than enough :)
1,048,576 rows and 16,384 columnsThat’s a composition of one Microsoft Excel sheet
the answer Depends on MSversion.
the number of raw and column differ for each version.Versions of Excel up to 7.0 had a limitation in the size of their data sets of 16K (214 = 16384) rows.
Versions 8.0 through 11.0 could handle 64K (216 = 65536) rows and 256 columns (28 as label 'IV'). Version 12.0 can handle 1M (220 = 1048576) rows, and 16384(214 as label 'XFD') columns.
It depend on version, in version 12 - 1048576 rows and 16384 column
Ten Lakh fourty eight thousand five hundered and seventy six Rows and Ten Lakh fourty eight thousand five hundered and seventy six columns
Asalaamualikum,
it depends on the version
as i know there are
64,000 rows
256 coloumn
