Selecting a range and dragging · 마틴과 코딩하기

One cell vs a whole block

A range is a connected rectangle of cells. A2:B6 is five rows in two columns. Formulas and formatting you often do on a whole range at once — not cell by cell.

You write a range address A2:B6 — top-left corner, colon, bottom-right corner. In Excel and Sheets the same.

💡

When a range is selected, at the top in the name box (left of the formula bar) A2:B6 lights up. You can type a range there and Enter — it gets selected.

Dragging with the mouse

Sheet Grades. Click A2. Hold the left button and drag to B5. A blue rectangle A2:B5.
Let go. The selection stays. Click outside — it disappears.
Again A2. Shift+click B5. The same range without dragging. More precise when you have a long table.

A whole column or row

Click letter A at the top → the whole of column A.
Click number 1 on the left → the whole of row 1.
Column A, Shift+click C → columns A, B, C.

⚠️

A whole column by mistake. When you press Delete on selected column A, everything in A disappears including Subject. Ctrl+Z. Better select only A2:A10.

Ctrl+A — what is selected

Click anywhere in the data (for example B3). Ctrl+A (Mac: Cmd+A) once selects the neighbouring block around the cursor. Ctrl+A a second time sometimes the whole sheet — watch out.

Try: cursor in B3, Ctrl+A. It should select the rectangle around the grades, not the whole planet.

A range for copying

Select A1:B6 (headings + data).
Ctrl+C. A new sheet or column F. F1. Ctrl+V.
The whole block copied at once.

🏫 Grade average

One sheet, two columns: subject and grade. At the bottom a sum and an average.

💰 Pocket money

Rows = days, columns = income / spend / left.

📊 Class survey

One question, answers in one column, later a chart.

🏆 Mini dashboard

Three numbers at the top and one chart. Numbers as a link, not copied by hand.

Now you 💪

You selected A2:B5 by dragging and by Shift+click — both ways.
In the name box the range address with a colon lights up.
Ctrl+A in the middle of the grades selects the data block, not the whole sheet by mistake (if it does, Ctrl+Z).
You copied range A1:B6 with one Ctrl+V elsewhere.
You know that a click on A at the top selects the whole column.

✅

Check: You can select a rectangle of cells. Range A2:B6 is not a foreign language to you.

What to take from this lesson

A range = a rectangle. It is written top_left:bottom_right.
Drag with the mouse or Shift+click the other corner.
Column/row by clicking the letter or number.
Ctrl+A selects the block around the cursor.
복사ing a whole range is faster than cell by cell.