Understand Cell Addresses and Ranges in Microsoft Excel 2013

Edited by Colette Cole, Crystal, Eng

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
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
  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
  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
  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
  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
  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
  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
  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
  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
    Advertisement

Video: Understand Cell Addresses and Ranges in Microsoft Excel 2013

If you have problems with any of the steps in this article, please post in the comments section below.

Comments

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

Article Info

Categories : Microsoft Suites

Recent edits by: Crystal, Colette Cole

Share this Article:

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