{"id":781,"date":"2020-08-21T09:40:58","date_gmt":"2020-08-21T09:40:58","guid":{"rendered":"https:\/\/apexuniversity.co.in\/LMS\/?p=781"},"modified":"2023-06-26T04:19:00","modified_gmt":"2023-06-26T04:19:00","slug":"cell-references-and-ranges-in-excel","status":"publish","type":"post","link":"https:\/\/lms.apexedu.org\/index.php\/2020\/08\/21\/cell-references-and-ranges-in-excel\/","title":{"rendered":"CELL references and ranges in Excel"},"content":{"rendered":"
Cell<\/strong><\/div>\r\n\r\n\r\n\r\n

An Excel worksheet is a combination of rows and columns where columns are identified by letters, and rows are identified by numbers. An excel is a grid of rows and columns.<\/p>\r\n\r\n\r\n\r\n

<\/figure>\r\n\r\n
\r\n\r\n A cell is a letter combined with a number.so if you combine the column B with row 5, you get cell B5.<\/div>\r\n\r\n
\r\n
\r\n\r\n A CELL is an intersection of individual rows and columns in the grid. Every excel worksheet is made up of hundreds of rectangles, which are called cells.<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

Each cell has its own cell address.<\/strong><\/p>\r\n

Reference<\/strong><\/p>\r\n\r\n\r\n\r\n\r\n\r\n

Cell references can indicate particular cells or cell ranges in columns and rows. Cell references identify individual cells in a worksheet they tell excel where to look for values to use in formula. This also refers to columns with letters and to rows with numbers. The letters and numbers are called row and column heading.<\/p>\r\n\r\n\r\n\r\n

For example: -A10 it is indicating cell A10.<\/p>\r\n\r\n\r\n\r\n

Types of cell reference<\/strong><\/p>\r\n\r\n\r\n\r\n

    \r\n
  • relative reference B5 <\/strong><\/li>\r\n
  • an absolute reference $B$5 where row and column is preceded by a $ dollar sign.<\/strong><\/li>\r\n
  • Mixed references has either an absolute column and a relative row or an absolute row and a relative column.<\/strong><\/li>\r\n
  • $A7 \u2013 absolute column, relative row<\/li>\r\n
  • A$7 \u2013 relative column, absolute row.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n
      \r\n
    1. Relative references changes as they are copied.<\/strong><\/li>\r\n
    2. Absolute references stay same as they are copied<\/strong>.<\/strong><\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n

      Range<\/strong><\/h3>\r\n\r\n\r\n\r\n

      A Range is a collection of two or more cells and it is separated by colon (:) but it is not necessary those cells are adjacent to each other.<\/p>\r\n\r\n\r\n\r\n

      Let\u2019s look at some example which demonstrate the different types of ranges.<\/p>\r\n\r\n\r\n\r\n

      \r\n
      Vertical Range\u00a0\u00a0 <\/strong> \r\n\r\n This vertical range is A1:A7 \u00a0\u00a0\u00a0\u00a0 <\/strong> \r\n\r\n\r\n
      <\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n
      Horizontal Range<\/strong> \r\n\r\n This horizontal range is A2:E2<\/strong> \r\n\r\n\r\n
      \"\"<\/figure>\r\n\r\n\r\n\r\n
      \u00a0<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
      \r\n
      Mixed Range\u00a0\u00a0\u00a0\u00a0 <\/strong> \r\n\r\n This range is A1:D7\u00a0\u00a0 <\/strong> <\/div>\r\n\r\n\r\n\r\n
      Multiple selection range<\/strong> \r\n\r\n This range is A2:B4, D4:E6<\/strong> <\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
      \r\n
      \r\n
      \"\"<\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n
      \r\n
      \"\"<\/figure>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

      Conclusion:<\/strong><\/h3>\r\n\r\n\r\n\r\n

      Nowadays MS-excel is used widely by everyone because it is the part of our daily office activity and helps in saving a lot of time.MS-excel can be used anywhere for any kind of work. For example, Accounting, Data Organization, Calculating, Managing Office Operations, Graphing. I have written this article to assist you to understand basic terminology of MS-Excel.<\/p>\r\n","protected":false},"excerpt":{"rendered":"

      Cell An Excel worksheet is a combination of rows and columns where columns are identified by letters, and rows are identified by numbers. An excel is a grid of rows and columns. A cell is a letter combined with a…<\/p>\n","protected":false},"author":1,"featured_media":782,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[101],"_links":{"self":[{"href":"https:\/\/lms.apexedu.org\/index.php\/wp-json\/wp\/v2\/posts\/781"}],"collection":[{"href":"https:\/\/lms.apexedu.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lms.apexedu.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lms.apexedu.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lms.apexedu.org\/index.php\/wp-json\/wp\/v2\/comments?post=781"}],"version-history":[{"count":0,"href":"https:\/\/lms.apexedu.org\/index.php\/wp-json\/wp\/v2\/posts\/781\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lms.apexedu.org\/index.php\/wp-json\/wp\/v2\/media\/782"}],"wp:attachment":[{"href":"https:\/\/lms.apexedu.org\/index.php\/wp-json\/wp\/v2\/media?parent=781"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lms.apexedu.org\/index.php\/wp-json\/wp\/v2\/categories?post=781"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lms.apexedu.org\/index.php\/wp-json\/wp\/v2\/tags?post=781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}