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.
- 4Now 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.
- 6The 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.
- 7You 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.
- 8A 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.
- 9That'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.Advertisement
Video: Understand Cell Addresses and Ranges in Microsoft Excel 2013
- If you have problems with any of these steps, ask a question for more help, or post in the comments section below.
Categories : Microsoft Suites
Recent edits by: Crystal, Colette Cole