Understand Cell Addresses and Ranges in Microsoft Excel 2013

Edited by Colette Cole, Crystal, Eng, Anonymous

Welcome to VisiHow. In today's video, we are going to show you how to understand cell addresses and ranges in Microsoft Excel 2013. If you haven't used Microsoft Excel 2013 before, or you don't have it installed on your computer yet, I would strongly recommend that you take a look at this article on how to Navigate Microsoft Excel 2013 , as well as this article on how to Create Project from a Blank Microsoft Excel 2013 Workbook. Start with those videos, then come back and join us for this video.

Was this helpful? Yes | No | I need help

How to Understand Cell Addresses and Ranges in MS EXCEL 2013.mp4-canvas11 169995.jpg

Ad

Steps

  1. 1
    To begin, open Microsoft Excel 2013.
    For the tutorial, I have the icon pinned to my taskbar. The Excel icon is a green book icon with a white "X" on it. Click it to open it.
    How to Understand Cell Addresses and Ranges in MS EXCEL 2013.mp4-canvas39 422892.jpg
    Advertisement
    Was this step helpful? Yes | No | I need help

  2. 2
    If yours is not pinned to your taskbar, you can simply do a search for it on your computer.
    For Windows 8, simply move your mouse over to the right side of the screen and click "Search". Type in "Excel" and it will show up in the list.
    How to Understand Cell Addresses and Ranges in MS EXCEL 2013.mp4-canvas43 958629.jpg
    Advertisement
    Was this step helpful? Yes | No | I need help

  3. 3
    Now that Excel is open and we are on the starting page of Excel, there is the option to open up recently created workbooks, as well as "Open Other Workbooks".
    For this tutorial, I will open a blank workbook.
    How to Understand Cell Addresses and Ranges in MS EXCEL 2013.mp4-canvas69 333055.jpg
    Was this step helpful? Yes | No | I need help

  4. 4
    Now we are in a Microsoft Excel 2013 workbook.
    The workbook area is the area that is highlighted. No matter what version of Excel you have, this portion of the workbooks look pretty much the same. It's the functions and layouts that have changed, as well as new and improved commands. Microsoft Excel 2013 is the most recent version available as of now, which is May, 2015. For details on releases, go to Microsoft.com. If you have it installed, you'll also get notifications via Windows Update.
    How to Understand Cell Addresses and Ranges in MS EXCEL 2013.mp4-canvas101 107084.jpg
    Was this step helpful? Yes | No | I need help

  5. 5
    On the top of the workbook, there are letters "A", "B", "C", and so on; those are your columns, which represent the vertical sections of your workbook.
    On the side, the rows are numerically labelled which represent the horizontal areas of your workbook.
    How to Understand Cell Addresses and Ranges in MS EXCEL 2013.mp4-canvas168 864334.jpg
    Was this step helpful? Yes | No | I need help

  6. 6
    The little blocks throughout the workbook are referred to as "Cells".
    A cell address is the point of intersection between a column and a row. For example, the address of the cell highlighted in the green box is D12; the D is highlighted grey as well as the 12. It is quite simple. You can select a cell using your mouse as well as using your arrow keys to navigate.
    How to Understand Cell Addresses and Ranges in MS EXCEL 2013.mp4-canvas198 316685.jpg
    Was this step helpful? Yes | No | I need help

  7. 7
    You can also go up to the Formula Bar, which is very useful if you have a large workbook, and type in =D12.
    As long as the equal sign is at the beginning, the cell will be highlighted blue. That is another way of finding a particular cell. Once you get into more complicated workbooks it is very useful. If you know the cell address you can quickly type in a formula instead of hunting the cell.
    How to Understand Cell Addresses and Ranges in MS EXCEL 2013.mp4-canvas255 101503.jpg
    Was this step helpful? Yes | No | I need help

  8. 8
    A cell range is basically a "group" or "range", as the title states.
    For example, I will start at A1, left-click and hold, and drag it to highlight a range of cells. Starting with what is at the top left-hand corner and ending with bottom right-hand corner, the range would be "A1:F15". So, in the Formula Bar, you can type "=A1:F15" and that range will be selected. This is useful especially when there is a calculation that you want to be done automatically in your workbook. For example, if you wanted the sum of the numbers from A1 to F15 to be in a separate cell, you could easily do that by typing in that particular range.
    How to Understand Cell Addresses and Ranges in MS EXCEL 2013.mp4-canvas340 183203.jpg
    Was this step helpful? Yes | No | I need help

  9. 9
    That's pretty much it for understanding cell addresses and ranges in Microsoft Excel 2013.
    That will conclude this tutorial. If you have any questions or comments about this video, please feel free to leave them in the comment section below. Thank you for watching VisiHow.
    How to Understand Cell Addresses and Ranges in MS EXCEL 2013.mp4-canvas404 166667.jpg
    Was this step helpful? Yes | No | I need help

    Advertisement

Video: Understand Cell Addresses and Ranges in Microsoft Excel 2013

Comments

VisiHow welcomes all comments. If you do not want to be anonymous, register or log in. It is free.




Creachhigher
Featured Author
34 Articles Started
1,088 Article Edits
6,075 Points
Creachhigher is a featured author with VisiHow. Creachhigher has achieved the level of "Sergeant" with 6,075 points. Creachhigher has started 34 articles (including this one) and has also made 1,088 article edits. 17,200 people have read Creachhigher's article contributions.
Creachhigher's Message Board
Creachhigher: Hi, my name is Creachhigher.
Creachhigher: Can I help you with your problem about "Understand Cell Addresses and Ranges in Microsoft Excel 2013"?
 

Article Info

Categories : Microsoft Suites

Recent edits by: Eng, Crystal, Colette Cole

Share this Article:

Thanks to all authors for creating a page that has been read 290 times.

Do you have a question not answered in this article?
Click here to ask one of the writers of this article
x

Thank Our Volunteer Authors.

Would you like to give back to the community by fixing a spelling mistake? Yes | No