Excel Working with Rows and Columns

Rows and columns are the building blocks of every Excel spreadsheet. Knowing how to insert, delete, resize, hide, and move rows and columns is essential for organizing data properly. This topic covers all the key operations for managing rows and columns.

Understanding Rows and Columns

In Excel:

• Rows are horizontal lines of cells, numbered from 1 to 1,048,576.
• Columns are vertical lines of cells, labeled A through XFD (over 16,000 columns).
• A cell is the intersection of one row and one column.

Selecting Rows and Columns

Selecting a Single Row

Click the row number on the left side of the screen. The entire row becomes highlighted.

Selecting a Single Column

Click the column letter at the top. The entire column becomes highlighted.

Selecting Multiple Rows or Columns

• Click the first row or column header, then hold Shift and click the last one to select a continuous range.
• Hold Ctrl and click individual headers to select non-adjacent rows or columns.

Inserting Rows and Columns

Inserting a Single Row

1. Click the row number where the new row should appear (the new row will be inserted above this row).
2. Right-click the row header.
3. Select Insert from the menu.

A blank row is added above the selected row, and all rows below shift down by one.

Inserting a Single Column

1. Click the column letter where the new column should appear (the new column will be inserted to the left).
2. Right-click the column header.
3. Select Insert.

Inserting Multiple Rows or Columns

Select the same number of rows (or columns) as the number to be inserted. Then right-click and select Insert. Excel will insert the exact number selected.

Example

  To insert 3 rows above Row 5:
  1. Select rows 5, 6, and 7 by clicking row headers.
  2. Right-click → Insert.
  3. Three blank rows appear above Row 5.

Deleting Rows and Columns

Deleting a Row or Column

1. Right-click the row number or column letter.
2. Select Delete.

The row or column is removed, and the remaining rows or columns shift to fill the gap.

Important: This is different from pressing the Delete key on the keyboard, which only clears the content of cells without removing the row or column itself.

Adjusting Row Height and Column Width

Resizing Manually

• For columns: Hover over the right border of a column header until the cursor changes to a double-headed arrow, then drag left or right.
• For rows: Hover over the bottom border of a row header and drag up or down.

AutoFit

AutoFit automatically adjusts the column width or row height to fit the content inside.

• Double-click the right border of a column header to AutoFit the column.
• Alternatively, select the column, go to Home → Format → AutoFit Column Width.

Setting an Exact Size

1. Right-click the row header or column header.
2. Select Row Height or Column Width.
3. Type the exact value and click OK.

Example

  Setting all columns to the same width:
  1. Select all columns (click the triangle in the top-left corner).
  2. Right-click any column header → Column Width → Type 15 → OK.
  All columns are now the same width.

Hiding and Unhiding Rows or Columns

Hiding is useful when certain data should not be visible temporarily but should not be deleted.

Hiding a Row or Column

1. Select the row(s) or column(s) to hide.
2. Right-click the header.
3. Select Hide.

The row number or column letter disappears from view. For example, if Row 3 is hidden, the numbers jump from 2 to 4.

Unhiding Rows or Columns

1. Select the rows or columns surrounding the hidden row or column. For example, to unhide Row 3, select rows 2 and 4.
2. Right-click the selected headers.
3. Select Unhide.

Moving Rows and Columns

Moving by Cut and Paste

1. Select the entire row or column by clicking its header.
2. Press Ctrl + X to cut.
3. Right-click the destination row or column header.
4. Select Insert Cut Cells.

Moving by Drag and Drop

1. Select the row or column.
2. Hover over the border of the selection until the cursor shows a four-headed move arrow.
3. Hold Shift and drag the row or column to the new position.

Freezing Rows and Columns

When scrolling through a large spreadsheet, headers can scroll out of view. Freezing keeps specific rows or columns visible at all times.

Freeze the Top Row

Go to View → Freeze Panes → Freeze Top Row. Row 1 will remain visible when scrolling down.

Freeze the First Column

Go to View → Freeze Panes → Freeze First Column. Column A stays visible when scrolling right.

Freeze Multiple Rows and Columns

1. Click the cell just below and to the right of the rows and columns to freeze.
2. Go to View → Freeze Panes → Freeze Panes.

Example

  To freeze the first 2 rows and the first column:
  Click on cell B3 (below row 2 and to the right of column A).
  Go to View → Freeze Panes → Freeze Panes.
  Rows 1 and 2, and Column A will remain visible while scrolling.

Unfreeze Panes

Go to View → Freeze Panes → Unfreeze Panes to remove the freeze.

Summary

• Rows are horizontal (numbered) and columns are vertical (lettered).
• Rows and columns can be inserted, deleted, resized, hidden, or moved.
• AutoFit adjusts the width or height to match cell content automatically.
• Hiding rows or columns keeps data in the file but removes it from view temporarily.
• Freeze Panes locks headers in place so they stay visible while scrolling through large datasets.