Row Column Understanding cells, rows, and columns, Insert, Delete, Hide:

1. Cells

• A cell is the smallest unit in a spreadsheet where data is entered.
• Each cell is identified by a column letter + row number (e.g., A1, B5).
• Cells can contain text, numbers, formulas, or functions.

2. Rows

• A row is a horizontal group of cells, identified by numbers (1, 2, 3, etc.).
• Example: Row 5 means all cells from A5 to the last column (e.g., XFD5 in Excel).

3. Columns

• A column is a vertical group of cells, identified by letters (A, B, C, …, AA, AB, etc.).
• Example: Column C means all cells from C1 to C1048576 (in Excel).

How to Insert Rows & Columns

Insert a Row

1. Right-click on a row number (e.g., Row 3).
2. Select Insert (Excel) or Insert row above/below (Google Sheets).
3. A new row will appear above the selected row.

Insert a Column

1. Right-click on a column letter (e.g., Column B).
2. Select Insert (Excel) or Insert column left/right (Google Sheets).
3. A new column will appear to the left of the selected column.

How to Delete Rows & Columns

Delete a Row

1. Right-click on the row number.
2. Select Delete (Excel/Google Sheets).
3. The row will be removed, and rows below shift up.

Delete a Column

1. Right-click on the column letter.
2. Select Delete (Excel/Google Sheets).
3. The column will be removed, and columns to the right shift left.

How to Hide & Unhide Rows & Columns

Hide a Row/Column

1. Right-click on the row number or column letter.
2. Select Hide (Excel/Google Sheets).
3. The row/column disappears but is not deleted.

Unhide a Row/Column

1. Select the rows/columns around the hidden one.
2. Right-click and choose Unhide (Excel) or Show (Google Sheets).
3. The hidden row/column reappears.