Every Excel worksheet/spreadsheet consists of columns and rows. The intersection of columns and rows make cells in Excel. Columns are labeled from A to XFD and rows range from number 1 to 1,048,576. Columns are labeled like this: After column Z comes column AA, then AB, AC, and so on. After column AZ comes to BA, then BB, BC, BD, and so on. After column ZZ is AAA, then AAB, and so on.
Table of Contents
The intersection of a row and a column creates a cell in Excel
The intersection of a row and a column is a single cell. Each cell in Excel has a unique address made up of its column letter and row number. For example, the address of the first cell is A1. Remember column letter will come first and row number will be placed second in a cell’s address. An Excel 2013 spreadsheet is made up of more than 17 billion cells. The address of the last cell in an excel spreadsheet is XFD1048576.
Command to find out the last cell in the Excel 2013 worksheet
Find the last row with this command: End⇒Down Arrow(↓), then find the last column with this command: End ⇒Right Arrow(→), you will reach the last cell of your Excel 2013 worksheet.
When you open an Excel spreadsheet, you will find one cell is selected with darker borders. This is the active cell. If you have created the spreadsheet just now, the active cell will be A1 by default. If you have opened an existing spreadsheet, the active cell will be the last cell you selected before saving and closing the spreadsheet.
Active cell means that it is active now if you enter something from your keyboard, it will accept the input. If there were something in the active cell, it will be deleted if you enter something this way. To edit the active cell, you have to double-click your mouse on the active cell or press Spacebar.
Row and column headings of the active cell appear in a different color to make it easier to identify the row and column of the active cell.