Understanding Cell And Range & Differences In Rows And Columns In Excel

Table of Contents[Show]
Understanding Cell And Range & Differences In Rows And Columns (Row And Column) In Excel

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 (Row) in Excel

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.

Understanding (Column) in Excel

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.

What is meant by cell or cells in Microsoft Excel?

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.

What is a range in Excel

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. 

Move between Cells 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:

←, ↑, →,↓ 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.

Leave a Comment