How to reference Range and Cells in Microsoft Excel

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 4,506 other subscribers

This article talks about how to reference range and cells in Microsoft Excel…


In my previous article, I have already talked about Cells and Range.  What I did not discuss in that article is how you can give cell or range a name.



How do you reference range when you have something to do with it. Let’s find out how to do that in this article.


reference range

First and foremost, in Microsoft Excel, Cells are identified by using cell references. You have to think of a cell reference as the name of a cell, used to differentiate it from among the other cells on a worksheet.



A cell reference consists of a letter and a number. The letter refers to the column border in Microsoft Excel, whereas the number refers to the new headers.


So, the cell on a worksheet that is located at the intersection of Column C and row 5 has the cell reference C5.


Furthermore, column Headers are displayed along the top of an Excel worksheet and are used to differentiate individual columns.



Columns headers begin with a letter A for the first column and run through the course of the entire alphabet. 


Also, Microsoft Excel supports far more column in a single worksheet than 25 letters of the alphabet.



A worksheet can contain up to 16, 384 columns. After letter Z, column headers continues through with AA after AZ comes to BA through BZ and so on and so forth.



Once the column headers have been exhausted, all of the possible combinations through ZZ, they continue with three letters such as AAA through ZZZ. 



By and large, row Headers are displayed along the left side of an Excel worksheet and are used to differentiate individual rows.


Row headers begin at 1 and increase sequentially through row 1,048,576. The last possible cell in Excel is XFD1048576.


One can use Range references to identify particular ranges of data in your worksheet. A range reference consists of two cell references separated by a colon.


The first cell reference identifies the top leftmost cell in the range; the second cell reference identifies the bottom rightmost cell in a range. For example, the range of cells that include the first five rows in columns A through D is A1: D5..



Action Point

If you enjoy our article, sign up to get our next article in your inbox.



You need to confirm your subscription by clicking on the link sent to you. You can check the spam folder for it. Add us to your mailing list to receive directly from us. Thanks.


PS: Click on the link below to sign up for my Online E-Course CRM Training. Make sure you confirm your subscription by clicking on the link sent to you. Thanks.

image_pdfGENERATE PDFimage_printPRINT
About crmnigeria 77 Articles
Adeniyi Salau C.E.P. C.S.C.U, M.C.P., M.C.T.P (MICROSOFT PROJECT 2016), Hubspot Inbound Marketing Expert is a Digital Marketer of repute who is committed to sharing his knowledge with readers out. He strongly believe I.T Knowledge is for everyone. He is already championing that cause.

Be the first to comment

Leave a Reply

Your email address will not be published.


CommentLuv badge