Selecting cells, rows, and columns in Google Sheets - Real Business Scenario

Scenario Mode

👤 Your Role: You are an office assistant managing a sales report in Google Sheets.

📋 Request: Your manager wants you to quickly select specific cells, entire rows, and columns to prepare the report for review.

📊 Data: You have a sales data table with columns: Date, Product, Region, Units Sold, and Revenue. The table has 10 rows of data.

🎯 Deliverable: You need to demonstrate how to select a single cell, a range of cells, entire rows, and entire columns in Google Sheets.

Sample Data

Date	Product	Region	Units Sold	Revenue
2024-06-01	Widget A	North	10	200
2024-06-02	Widget B	South	15	300
2024-06-03	Widget A	East	8	160
2024-06-04	Widget C	West	20	400
2024-06-05	Widget B	North	12	240
2024-06-06	Widget A	South	7	140
2024-06-07	Widget C	East	18	360
2024-06-08	Widget B	West	14	280
2024-06-09	Widget A	North	9	180
2024-06-10	Widget C	South	16	320

1

Step 1: Select a single cell to view or edit its content.

Click on cell C4 (which contains 'West').

Expected Result

Cell C4 is highlighted, showing the value 'West'.

2

Step 2: Select a range of cells to work with multiple data points.

Click and drag from cell B2 to D4 to select the range B2:D4.

Expected Result

Cells from B2 to D4 are highlighted, including Product, Region, and Units Sold for first three rows.

3

Step 3: Select an entire row to apply formatting or analyze data for that day.

Click the row number 5 on the left side to select the entire 5th row.

Expected Result

Row 5 is highlighted across all columns, showing data for 2024-06-05.

4

Step 4: Select an entire column to analyze or format all data in that category.

Click the column letter D at the top to select the entire 'Units Sold' column.

Expected Result

Column D is highlighted from row 1 to row 11, showing all units sold values.

Final Result

  Date       Product   Region   Units Sold   Revenue
-----------------------------------------------------
 2024-06-01  Widget A  North    10          200
 2024-06-02  Widget B  South    15          300
 2024-06-03  Widget A  East     8           160
 2024-06-04  Widget C  West     20          400
 2024-06-05  Widget B  North    12          240
 2024-06-06  Widget A  South    7           140
 2024-06-07  Widget C  East     18          360
 2024-06-08  Widget B  West     14          280
 2024-06-09  Widget A  North    9           180
 2024-06-10  Widget C  South    16          320

Selections demonstrated:
- Single cell C4 selected (value: West)
- Range B2:D4 selected
- Entire row 5 selected
- Entire column D selected

✓You can select a single cell by clicking it once.

✓Click and drag to select multiple cells in a range.

✓Click the row number to select the entire row.

✓Click the column letter to select the entire column.

Bonus Challenge

Try selecting multiple non-adjacent cells or ranges using the Ctrl (Cmd on Mac) key.

Show Hint

Hold Ctrl (Cmd) and click on different cells or drag ranges to select them together.