Understand Cell Addresses and Ranges in Microsoft Excel 2013

3 Parts:

Steps

Video: Understand Cell Addresses and Ranges in Microsoft Excel 2013

Comments

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.

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.

   

   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.

   

   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.

   

   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.

   

   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.

   

   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.

   

   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.

   

   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.

   

   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.

   

   Was this step helpful? Yes | No| I need help

If you have problems with any of the steps in this article, please ask a question for more help, or post in the comments section below.

Comments