Difference Between Row and Column

Key Difference: The key difference is that a row is horizontally arranged in a straight line from left to right, while a column is vertically divided from top to bottom. In Excel-sheet a row is numerically valued while a column is alphabetically tagged like A1 cell in the sheet that shows A as column and 1 as the row.

Row and Column​​​A row is a noun with the basic definition of row being a number of things or people arranged in more or less straight horizontal line, while a column also noun which is a vertically arranged list. 

The origin of the word row is from Old English rowan of Germanic origin; related to rudder; from an Indo-European root shared by Latin remus 'oar', Greek eretmon 'oar', while the origin of column came from Middle English Rowcolumne from Latin columna. A row goes length-wise across the field or over the water and a column is measured height-wise. By default Excel uses letters for column and numbers to label the row. A row is precise and specific with information about certain thing like gender, age, marks while a column consists of similar information but in a more broader concept with everything listed.

In context to relational database, where row is also called as tuple will have a single data item in a table like for example, where a table represents data regarding companies then each row will represent one single company Columnname. Columns might represent things like company name, address and other relevant data. In a spreadsheet, rows are from left to right on a level plane, while a column is vertically from top to bottom from max. to min. In general usage rows and columns are generally most used in Excel or Spreadsheet and is also commonly used as sitting arrangement more specifically in a theatre with row either numerically or alphabetically labeled and a column is more used to denote the style of pillars in designing or a vertical list in a table or daily paper articles divided in a column structure. Column is a single stack of cells, whereas a row is a single string of cells.

    Comparison between Row and Column:

    Particulars

    Row

    Column

    Definition

     

    • A horizontal line of entries in a table.

    • A street with a continuous of houses along one or both its sides.

     

    A vertical data list in a table.​

    Examples

    A row in a theatre or in a classroom.

    A column in an application form .

    Excel-sheet

    Row is generally numbered.

    While column is labeled alphabetically or by letters.

    Arrangement

    From left to right.

    From top to bottom.

    Data

    Describes data specifically like a company's names -XYZ.

    While a column will have general data like Companies which will be more precisely mentioned in a row.

    Image Courtesy: Idoceonline.com, Lifewire.com, Quora.com

    Most Searched in Education and References Top 10 Most Searched Differences
    Most Searched in Games and Recreation Most Searched Non-Alcoholic Drinks
    Drupal 6 vs Drupal 7
    Samsung Galaxy Tab 3 7.0 vs Samsung Galaxy S4
    iPhone 5S vs iPhone 5C
    Spice Stellar Pinnacle Pro vs Nexus 4

    Add new comment

    Plain text

    CAPTCHA
    This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.