Explaining the meaning of cells, the meaning of ranges, the meaning of rows and the meaning of columns in Excel as well as the differences in rows and columns & how to move between cells in Microsoft Office Excel
How do you understand cell, range, row and column in Microsoft Excel?
After explaining the differences between workbooks and worksheets in Microsoft Excel, in this Excel tutorial we will learn about the meaning of Cell, the meaning of Range and explain the meaning and difference between rows and columns in Microsoft Excel.
This excel tutorial is intended for those of you who are truly zero and new to Ms. excel. For those of you who already understand the basic concepts of using Excel, you can skip this tutorial. However, there is nothing wrong with reading it first, maybe there are one or two things that you don't know yet, for example about tips on how to move between Excel cells at the end of this tutorial.
If you've read the previous explanation of the workbook (worksheets) and worksheets (workbook) excel that has been reviewed previously, this section will understand more easily again. Because in this section the Excel Class has also mentioned a little about the meaning of the terms Row, Column, Cell and Range in Microsoft Excel.
Before discussing the meaning of cell and range, we first discuss the meaning of row and column in Excel.
Understanding (Row) in Excel
The definition of “Row " is a part of the
worksheet that runs horizontally to the side and is marked with the numbers 1,
2, 3 to 1,048,576.
Understanding (Column) in Excel
The “column ", is part of a worksheet that ran vertically up and marked with the letters A, B, C, and so on until XFD.
Difference between rows and columns in Microsoft Excel
In Excel 2003, the number of Excel rows or rows provided by Excel is only 65,536.
Starting from the Excel 2007 version, the number of rows or rows in Microsoft Excel is 1,048,576. The last number at the bottom of the worksheet on the left shows the number of rows provided by Microsoft Excel.
Meanwhile, the number of columns in Excel 2003 is only up to letter IV or 256 columns, whereas in the Excel version of 2007 and above the number of columns provided by Microsoft Excel is up to the letter XFD which is the 16,384 column.
| Version | Numbers of Rows | Numbers of Columns |
|---|---|---|
| Excel 365 | 1,048,576 | 16,384 |
| Excel 2019 | 1,048,576 | 16,384 |
| Excel 2016 | 1,048,576 | 16,384 |
| Excel 2013 | 1,048,576 | 16,384 |
| Excel 2010 | 1,048,576 | 16,384 |
| Excel 2007 | 1,048,576 | 16,384 |
| Excel 2003 | 65,536 | 256 |
| Excel 2002 / XP | 65,536 | 256 |
| Excel 2000 | 65,536 | 256 |
| Excel 97 | 65,536 | 256 |
| Excel 95 | 16,384 | 256 |
| Excel 5 | 16,384 | 256 |
From the explanation of the definition of columns and rows above, it is clear that the difference between columns and rows apart from their vertical and horizontal length also lies in their numbers.
After explaining the meaning of Row and Column and the differences in rows and columns, in the next section we will discuss the meaning of Cell and also about the meaning of Range in Microsoft Excel.
Understanding (Cell) in Excel
What is meant by cell or cells in Microsoft Excel?
Understanding Cell is a small box on the worksheet which is the meeting point between Row and Column.
An excel cell is usually given a name or address
according to the column name and row number. For example, the meeting point
between column C and row number 5 is called Cell C5, in other words Cell C5 is
an excel cell in column C and row 5.
You can see the name or address of the active cell in the formula bar on the left which is called the name box as seen in the picture above.
In Excel 2003 and below, the number of excel cells in a worksheet is 16,777,216. Whereas in Excel 2007 and above in a worksheet containing 17 billion cells or numbers to be precise 17,179,869,184 cells.
Understanding (Range) in Excel
What is a range in Excel?
If Cell is a meeting between Row and Column or meeting of Rows and Columns, then terms is defined as a range is a collection of several cells in Microsoft Excel.
So the notion of Range is a combination of several cells in Microsoft Excel, either in one or more rows and columns.
A group of cells that are joined and called a range
here can be in one row, one column, or several rows and columns.
- An example of a single line range is for example A1: F1.
- An example of a one-column range is for example A1: A5.
- An example of a range for several columns and lines is for example A1: F5.
A cell or range on an Excel worksheet can also be given a specific name so that it is easy to remember as needed. You can read the method on the following page: Naming the Range in Excel.
Apart from using the mouse to activate or select a cell, we can also activate or move between cells using the buttons on the keyboard.
The shortcut keys on the keyboard that you can use to
move between cells in a worksheet include:
| SHORTCUT | FUNCTION |
|---|---|
| ←, ↑, →,↓ | Move one cell left, up, right or down |
| Tab | Move one cell to the right |
| Shift + Tab | Move one cell to the left |
| Enter | Move down one cell |
| Shift + Enter | Move up one cell |
| Ctrl + → | Move one cell to the left of the first column |
| Ctrl + ← | Move one cell to the right of the last column |
| Ctrl + ↑ | Move one cell to the top of the first row |
| Ctrl + ↓ | Move one cell down to the last row |
| Home | Move to column A |
| Ctrl + Home | Move to cell A1 |
| PgUp | Move up one screen |
| PgDn | Move down one screen |
| Alt + PgUp | Move one screen to the left |
| Alt + PgDn | Move one screen to the right |
| Ctrl + PgUp | Move to the next worksheet |
| Ctrl + PgDn | Move to the previous worksheet |
That's a little explanation about the meaning of row, column, cell and range in Microsoft Office Excel. Next, please learn some of the following basic excel guidelines.
Before leaving, don't forget to bookmark and share this excel tutorial article with the buttons provided below. Greetings Excel Class.