Rows & Columns in Excel 2010
Row and Column Basics
MS Excel is in tabular format consisting of rows and columns.
Row runs horizontally while Column runs vertically.
Each row is identified by row number which runs vertically at the left of the sheet.
Each column is identified by column header which runs horizontally at the top of sheet
For MS Excel 2010 Row numbers ranges from 1 to 104857 in total 1048576 rows and Columns ranges from A to XFD in total 16384 columns
Navigation with rows and columns
Let us see how to move to last row or last column.
You can go to last row by clicking Control + Down Navigation arrow.
You can go to last column by clicking Control + Right Navigation arrow.
The intersection of rows and columns is called cell. Cell is identified with Combination of column header and row number. For example: A1, A2