Cells & Ranges

On a worksheet, a cell's row number (such as "A1") and column letter indicate its location. This is commonly known as the cell address.
A range of cells is a collection of neighboring cells, and all of the cells on a worksheet are divided by gray lines called gridlines.
To identify cells and ranges, three different kinds of cell reference operators are available. the space, colon, and comma.

Colon ( : ) - A range of cells (such as "A1:D4") can be defined using the colon (:). The top left cell and bottom right cell references, separated by a colon, are used to describe a range of cells.

Comma ( , ) - This is how non-adjacent cells (like "A1" and "B2") are defined. Another name for the comma is the union operator.

Space ( ) - The intersection of two cell blocks (such as "A1:D4 B2:C3") can be combined using this method. The two cell blocks must overlap when using this operator. If not, an error notice will show up. The intersection operator is another name for the space.
Non-adjacent or non-contiguous ranges are frequently used to describe several cell ranges. These are cell ranges that don't form a tidy rectangular block.

Entering data

Three main kinds of data can be entered into cells. This can occasionally be increased to four because some people consider Dates & Times to be a distinct kind.

Numerical - In essence, these are values or numbers. Dates and times that are regarded as serial numbers fall under this category. This enables the manipulation of times and dates in formulas, including the addition and subtraction of dates.

Text -   In essence, these are words or any type of textual data. These can alternatively be referred to as strings or labels. Since text entries cannot be calculated, they are regarded as labels.

Formulas - These enable you to carry out mathematical operations and all begin with an equal symbol (=).
The contents of a cell will be overwritten if you select it and begin typing.
Either the formula bar or the cell itself can be used to enter (and modify) the contents of cells.
Check your (Tools > Options) (alter tab, "Edit directly in cell") if you are unable to alter the contents of the cells directly.

Selecting Data

You have to choose the cell before you can enter data into it.
On a worksheet, several cells may be selected at once, but there will only ever be one Active Cell.
There is always a black border around the active cell.
The "Name Box" to the left of the Formula bar always shows the address of the current cell.

Only the upper left cell is regarded as the active cell when a range of cells is chosen.
The active cell is shown as white if a range of cells is chosen.
Click anywhere outside the range or use any of the arrow keys to deselect a cell or range of cells.
There are many shortcut keys that can be used to select data, but the most helpful one is probably Ctrl + Shift + 8, which selects the current region.

Moving data

Excel saves data in a temporary memory known as the clipboard whenever you copy a cell.
Until it is replaced by new data, the data will remain there. Only a future Cut or Copy command will take its place.
In line with other applications, the shortcut keys Ctrl + C, Ctrl + X, and Ctrl + V stand for copying, cutting, and pasting data, respectively.
Alternatively, you can paste the current entry from the clipboard by just pressing Enter.

Sorting data

Your data can be sorted and rearranged in a variety of ways.
Rows and columns can be sorted in both ascending and descending order.
The rows are rearranged and the columns stay in the same order when sorting by rows.
Regardless of their alphabetical order, you can create your own unique sorting order.
It is crucial to keep in mind that text values are sorted after numerical values.
By default, there are four custom lists with days and months in them. The items will be automatically sorted into the proper chronological sequence (e.g., Mon, Tue, Wed or Jan, Feb, Mar, etc.) if you sort by a column that contains entries from one of these four custom lists.