524 tips · new ones added continuously
Every tip is one concrete thing you will do better or faster. Filter by what you use and who you are — or just search.
You don't have to drag a formula across a thousand rows — double-clicking the little black square copies it down to the end of the adjacent data.
Data validation turns a cell into a menu of allowed values. Task statuses or categories can no longer be typed wrong.
Data → Remove Duplicates cleans up a list of contacts or line items — and tells you how many it deleted.
Ctrl+;
Ctrl+semicolon inserts today's date as a fixed value — unlike the TODAY() function, it doesn't change.
Alt+Enter
Enter jumps to the next cell — Alt+Enter creates a line break inside the same one. No more broken layouts.
View → Freeze Panes keeps the table header locked at the top no matter how far you scroll.
The best tip of the week, by email
Don't want to browse hundreds of tips? Once a week I send you the one that pays off most. Two minutes to read.
The Top 30 tips e-book, free — it lands in your inbox right away.
Then 1 tip a week · no spam · unsubscribe in one click
The newer replacement for VLOOKUP searches in either direction, doesn't break when a column gets inserted, and has a built-in “not found” fallback.
Duplicate values, overdue deadlines, or below-average results highlight themselves — you just define the rule.
Ctrl+E
Type one example into the next column (say, a name pulled from an email address) and Ctrl+E fills in the rest to match. No formulas.
Ctrl+T
Ctrl+T turns a range into a “smart” table — automatic filters, formatting for new rows, and readable formulas.
An empty calendar is an invitation to meetings. Block off your mornings for deep work before someone else does it for you.
F4
One key, two superpowers — repeating your last action and toggling dollar signs in a formula.
Ctrl+↓
Don't scroll through a sheet with thousands of rows. Ctrl+arrow jumps to the end of the block, and with Shift it selects as it goes.
Anything that takes less than two minutes, do right when you read it. Longer things go to your task list — and archive the email.
Win+S
When Windows can't “find” your files, it's probably not indexing the right folders. One search setting fixes it all.
Windows can reopen the apps that were running before a restart. An overnight update doesn't have to mean rebuilding your workspace in the morning.
Ctrl+P
The virtual printer “Microsoft Print to PDF” makes a PDF out of any app that can print — a webpage, an email, even an invoice from your accounting software.
Win+V
Clipboard history (Win+V) can sync through your Microsoft account — copy something on your work PC, paste it on your laptop.
Blue light in the evening delays falling asleep. Windows can automatically warm up the screen after sunset.
Win+Z
Hover over the maximize button (or press Win+Z) and pick where the window belongs — halves, thirds, a grid.
Win+H
Voice typing in Windows works in your language and starts wherever the cursor is blinking. Dictate a first draft of an email in a third of the time.
Win+Ctrl+→
Win+Ctrl+D creates a new desktop, Win+Ctrl+arrows switch between them. Slack on one, focused work on the other.
Win+E
A new folder, finding a file, copying — it all starts with File Explorer. Open it with a shortcut, not by hunting for an icon.