ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

How Many Columns and Rows are there in MS Excel?

user-image
تم إضافة السؤال من قبل Harish potnuri , HR Executive , DBS BANK
تاريخ النشر: 2018/01/30
Rehnuma Rehnuma
من قبل Rehnuma Rehnuma , MIS Executive , Samsung India Electronics Ltd

 

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

Sinan Altin
من قبل Sinan Altin , International Sales Director , Tio Medikal

it depends on your monitor resolution

Muhammad Umair
من قبل Muhammad Umair , Distribution Officer , GT Pharma Pvt Ltd, Lahore Pakistan

There is no maximum number limit however, if any, there should be 10 lac rows and 16k columns. 

ABDULRAHMAN A ALKHAMEES
من قبل ABDULRAHMAN A ALKHAMEES , Early Conditional Retirement , Saudia Airlines

by copying the column and paste as transpose

Firas Shahadi
من قبل Firas Shahadi , Human Resources Director , SAUDI UNION

More than you need  and more than enough :)

Samuel Getachew
من قبل Samuel Getachew , Chief Medical Laboratory Technician , Health Center

1,048,576 rows and 16,384 columnsThat’s a composition of one Microsoft Excel sheet

صالح العتيبي
من قبل صالح العتيبي , PMO adviser , Riyadh Municipality

the answer Depends on MSversion.

Emu Bethankful
من قبل Emu Bethankful , lecturer , debre tabor university

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.

Ismail Hydrus
من قبل Ismail Hydrus , Accounts Manager , Sanabel AL Ataa

It depend on version, in version 12 - 1048576 rows and 16384 column

Manikandan Balasubramanian
من قبل Manikandan Balasubramanian , Instrumentation Project Engineer , SSE AUTOMATION & SOLUTIONS

Ten Lakh fourty eight thousand five hundered and seventy six Rows and Ten Lakh fourty eight thousand five hundered and seventy six columns

Mohammed Aamir Suhail
من قبل Mohammed Aamir Suhail , HVAC Engineer , Pristine Investments Ltd

Asalaamualikum,

it depends on the version

as i know there are

64,000 rows

256 coloumn

المزيد من الأسئلة المماثلة