You show the range of cells from A1 to A23 like this: A1:A23.
range finder
You do not indicate what problem you want to fix, so I will not be able to give you a meaningful answer. You can format cells, by clicking on the cells or range you want to format, then select format cells.
A Range
Yes, a range is a contiguous block of cells.
They are unipotent.
They can be called a range or a block.
A range is a collection of cells (e.g. A1:A4 is the range of the cells from A1 to A4).
The Criteria Range is a range of cells that hold cells from which criteria are tested for functions in Excel.
They are unipotent.
they are unipotent
An input range could be the range of cells a function needs to be entered to do its task. Many functions use input ranges. If you wanted a sum of a range of cells and specified them in a range, that would be an input range. In the following example the cells from A2 to A20 are the input range: =SUM(A2:A20)