Select Special

Why use data processing

After finding and selecting cells with Select Special, you often need to do something with that selection — extend it to full rows or columns within the data region, or apply calculations. Instead of manually adjusting selections or writing formulas one by one, Select Special can process your selection automatically.

Available actions

Select Special provides two processing actions:

How to process selected cells

1. Find and select cells

Use any Select Special action to find cells (e.g., "Entered values", "Formulas", "Cells with notes").

2. Review results

After the search completes, you'll see the list of found cells. Click Next to proceed to processing.

3. Choose processing action

Select either "Expand Selection" or "Add Formula" and configure the options.

4. Process

Click Process to execute the action. You'll see a summary with the results.

Expand Selection

Extends your selected cells to the boundaries of the surrounding data region (table).

Options

Choose one of the expand modes:

Expand selection to data row — extends selection horizontally to the data region edges.

Expand selection to data column — extends selection vertically to the data region edges.

How it works

1. Select Special determines the data region for each selected cell
2. Each selection is extended in the chosen direction until it reaches the data region boundary
3. Overlapping selections are merged automatically

Example: Select full rows for highlighted cells

You have a table with project tasks and want to select the entire row for every cell with a yellow background:

1. Use "Fill colors" to find all cells with a yellow background
2. Choose "Expand Selection" → "Full row" → "Both"
3. Click Process

Result: Every found cell's selection now spans the full width of the data region, giving you complete rows ready for further action.

Add Formula

Inserts a formula next to your selected cells to calculate values.

Options

How it works

1. Select Special determines the data region for your selection
2. For each row (or column), it creates a formula referencing the selected cells
3. Formulas are placed in a new column after your data (or new row below)

Example: Count values by color

You have a spreadsheet with cells highlighted in different colors (e.g., red for urgent, yellow for pending, green for done). You want to count how many text entries exist for each color.

1. Use "Fill colors" to find all cells with a specific background color
2. Apply Text filter to include only text values (exclude numbers or blanks)
3. Choose "Add Formula" → "New row" → "COUNTA"
4. Click Process

Result: A COUNTA formula appears below your data, showing the number of text values with that fill color.

Processing summary

After processing completes, you'll see a summary showing:

For Expand Selection:

• Number of selections expanded
• Direction used

For Add Formula:

• Number of formulas added
• Function used
• Target location (column or row)