The cells of a spreadsheet are positioned in a grid pattern defined by columns and rows.
What’s the Difference?
Columns run vertically, up and down.
Most spreadsheet programs markcolumns headingswith letters.
Rows, then, are the opposite of columns and run horizontally.
Rows are numbered, not lettered.
One easy way to remember the difference between columns and rows is to think about real-world scenarios.
For example, torefer to a cellin Column G that’s in Row 15, you’d specifyG15.
The column always goes first followed by the row, without a space.
For example, Google Sheets starts off with 26 columns and 1,000 rows.
26 (Column Z).
To do this, column names are normally appended with the start of the alphabet again.
For example, Row 26 might read AA, Row 27 AB, and so on.
Excel worksheets are limited to having 16,384 columns and 1,048,576 rows.
In Excel, the very last column heading is called XFD to indicate Column 16,384.
Selecting a whole row is similar: smack the row number or useShift+Spacebar.
