You work with rows and columns when using a spreadsheet program. Themaximum number of rows and columns offered in a single worksheet inExcel 2019 is the following:
The Excel document window consists of the following:
- Rows that are numbered vertically from
1 to 1,048,576 on each sheet
- Columns marked horizontally from A-Z, AA-ZZ, up to XFD—16,384columns on each sheet
An example of a row and a column is provided in the followingscreenshot:
The number of columns displayed when viewing a worksheet on thescreen depends on the column widths and computer screen size. You mayneed to scroll either to left or right to see anything that cannot fitinto the screen display.
To view the number of columns and rows resident on a worksheet,proceed as follows:
Click on the Select All icon withthe left mouse button and hold the mouse depressed to see the column androw indicators in the Name Box area,as illustrated in the following screenshot:
Or click on the Hometab, visit the Find &Select group, and then click on
A cell is a position on the worksheet where the rowsand columns cross (intersect). The cell address is theposition at which the column letter and row number intersect. Anactive cell contains a thick border. The border indicates theplace on the worksheet where the mouse pointer currently resides and isready for data input. Text aligns to the left, and values are aligned tothe right when entered.
Once data is typed into a cell, press the Enter key on thekeyboard to confirm the entry, and the cursor will move down one cell.Alternatively, click on another cell using the mouse pointer, directlyafter typing the data, or press an arrow key on the keyboard to move thecursor, as illustrated in the following screenshot: