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. A column has many other different definition and meanings to it like:

  • A column in architecture is a rigid, relatively slender upright support composed of few pieces or a decorated pillar having a cylindrical or polygonal shaft.

  • A vertical data list in a table.

  • A regular feature or series of articles in newspaper, magazine.

  • In Botany, a column like structure in an orchid flower, composed of united stamens and style.

Whereas, a row also has a different meaning and definition of the word like:

  • To row also means rowing a boat with oars.

  • A horizontal line of entries in a table.

  • A serious dispute or a quarrel.

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

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

    • To row also means rowing a boat with oars.

    • A horizontal line of entries in a table.

    • A serious dispute or a quarrel.

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

    • A column in architecture is a rigid, relatively slender upright support composed of few pieces or a decorated pillar having a cylindrical or polygonal shaft.

    • A vertical data list in a table.

    • A regular feature or series of articles in newspaper, magazine.

    • In Botany, a column like structure in an orchid flower, composed of united stamens and style.

    Examples

    A row in a theatre or in a classroom.

    A column in a newspaper or a Greek column pillar in a building.

    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.

    References: Quora.com, Yahoo.com, Oxfordictionaries.com (Row, Column),
    Dictionary.com (Row, Column), Wikipedia.org (Row, Column)
    Image Courtesy: Idoceonline.com, Lifewire.com, Quora.com

    Most Searched Non-Alcoholic Drinks Most Searched in Computers and Internets
    Most Searched in Beauty and Style Most Searched in Games and Recreation
    Class vs Structure in C++
    Green Card vs Permanent Resident
    Acrylic, Silk wrap, vs Gel nails

    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.