Excel Structure
The Excel Structure
Understanding Workbooks, Sheets, and the Grid
Think of Excel as a digital filing cabinet. The Workbook is the entire cabinet, and the Worksheets are the individual folders inside. Every worksheet is built upon a grid of rows and columns.
The entire Excel file (usually ending in .xlsx).
A single tab/page inside the file.
Horizontal lines identified by Numbers (1, 2, 3...).
Vertical lines identified by Letters (A, B, C...).
The Cell: Where the Magic Happens
A Cell is the rectangular box where a Row and Column meet. Every cell has a unique Address (or Reference).
Column A + Row 1
Column C + Row 5
How to find your location?
Look at the Name Box (the small box above Column A). It always displays the address of the cell you have currently selected. This is vital when you start working with large amounts of data!
A single Excel worksheet contains 1,048,576 rows and 16,384 columns! That is plenty of space for almost any project.