Identifying rows, columns, and cells in Microsoft Excel 2019

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:

ms office 649

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:

ms office 101

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:

ms office 19

Or click on the Hometab, visit the Find &Select group, and then click on Go To…. In the Go To dialog box, typeXFD1048576 (this is the last column and last row of theworkbook).

To move from the very last row and column on a worksheet without havingto scroll for ages, hold down the Ctrl key and then press theHome key to move instantly to cell A1. To go back to the activecell, we use the Ctrl key and the Backspace key.

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:

ms office 558

Leave a Comment