Skip to content

Data Manipulation & Mechanics

Core Data Manipulation & Shortcuts

Data Cleaning Toolkit

Flash Fill

Automatically detects patterns in your data and fills the remaining rows. * Path: Home > Fill > Flash Fill * Execution Rule: You must provide at least one clear example in the adjacent column right before executing. * Shortcut: Ctrl + E (Use Ctrl + Z to undo/cut if the pattern misinterprets).

Remove Duplicates

Cleans redundant records from a dataset. * Path: Data Ribbon > Remove Duplicates * Critical Behavior: Selecting a single header column will evaluate duplicates based on that column alone, matching and removing the corresponding data across all rows.

Text to Columns

Splits a single cell of text into multiple columns based on a delimiter (comma, space) or fixed width. * Path: Data Ribbon > Text to Columns * Shortcut: Alt + A + E

  • Select Column to Bottom: Ctrl + Shift + Down Arrow
  • Select Header Row to End: Ctrl + Shift + Right Arrow
  • Select Entire Sheet/Table: Ctrl + A
  • Move Data Safely: Ctrl + X followed by Ctrl + V
  • Apply Bold Formatting: Ctrl + B
  • Cell Editing: Double-click the cell or press F2 to edit inline without overwriting.
  • Column Auto-Fit: Select data, go to Home > Cells > Format > AutoFit Column Width. If text is too long, use Wrap Text combined with AutoFit Row Height.

Sheet Worksheet Management

  • Creating: Home Ribbon > Insert > New Sheet (or right-click tab).
  • Deleting: Right-click the sheet tab > Delete.
  • Hiding: Right-click the sheet tab > Hide.
  • Renaming: Double-click the sheet tab directly.
  • Duplicating/Moving: Right-click sheet tab > Move or Copy > Check Create a copy > Choose target workbook (e.g., (new book)).

Clipboard Mechanics & Paste Special

The Format Painter

Copies only visual formatting (colors, font sizes, borders, highlights) and leaves underlying values unchanged. Represented by the Brush Symbol to quickly make raw data readable.

Paste Special Matrix

Use these tailored options via the Paste Options menu or Paste Special dialog:

Paste Intent Action / Menu Choice Outcome
Strip Formulas Paste Only Values Overwrites formulas with permanent, flat static data values.
Flatten Math Models Formulas and Number Formats Keeps formulas and formatting while stripping visual shapes or borders.
Clean Layout No Borders Pastes all cell attributes completely while omitting grid lines/borders.
Patch Incomplete Data Skip Blanks Prevents empty cells in your copied range from overwriting existing data.
Batch Apply Percentages Paste Special > Values > Multiply Multiplies a destination range by the copied number (e.g., scaling by a decimal).
Batch Updates Paste Special > Add / Subtract Adds or subtracts the copied value directly into destination cells.

Copy as Picture

Used to prevent external stakeholder tampering. * Static Picture: Select data > Copy Dropdown > Copy as Picture. The resulting image cannot be modified. * Linked Image: Pastes the data as an image that automatically updates whenever changes are made to the original source cells.