Home / Excel

Excel tips and tricks nobody tells you about

Shortcuts and hidden features for Microsoft Excel — small, specific, and easy to use today.

All tips Word Excel PowerPoint Canva

Excel tips

XExcel

The feature that finishes typing your data for you

Flash Fill spots the pattern in your first two entries and fills in the rest of the column itself.

3 min read XExcel

Select an entire table with a single shortcut

Ctrl+Shift+8 grabs the whole current data region — no dragging, no missed rows.

2 min read XExcel

Turn a plain number into a tiny bar chart, in the cell

Data bars from conditional formatting draw straight into the cell — no separate chart needed.

2 min read XExcel

Build a chart or summary from a tiny floating icon

Select your data and the Quick Analysis icon appears in the corner — one click previews charts, totals and formats.

2 min read XExcel

Let Excel suggest the PivotTable for you

Insert > Recommended PivotTables scans your data and offers ready-made summaries instead of building one from scratch.

3 min read XExcel

Keep your header row visible while you scroll

Freeze Panes locks the top row or first column in place — no more losing track of which column is which.

2 min read
Ad placeholder — 728×90 responsive unit
XExcel

Give a cell range a name instead of a reference

Define Name turns =B2:B40 into =SalesQ1, so your formulas actually read like sentences.

3 min read XExcel

Insert today's date or the time with one keystroke

Ctrl+; drops in today's date, Ctrl+Shift+; drops in the current time — no typing, no formula.

1 min read XExcel

Show "$1.2k" without changing the real number underneath

A custom number format changes how a value displays while keeping the exact figure intact for formulas.

2 min read XExcel

Copy a formula down a whole column without dragging

Double-click the small square at a cell's bottom-right corner — it fills down automatically to match the column beside it.

1 min read