Grouping Sheets: Edit a Dozen Excel Sheets at Once
Ctrl+click on sheet tabs groups them — and whatever you type into one gets written into all of them. Fix twelve monthly sheets in one move.
502 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.
Ctrl+click on sheet tabs groups them — and whatever you type into one gets written into all of them. Fix twelve monthly sheets in one move.
Switching back and forth between the sheet with source data and the sheet with results? View → New Window shows both at once.
Alt+;
Copying a table with hidden rows and they paste in too? Alt+; selects only the visible cells — the hidden ones stay home.
“You froze” usually doesn't mean slow internet — it means unstable Wi-Fi. An Ethernet cable is the single most reliable upgrade for calls.
Put the meeting window on the monitor with the camera, notes and materials on the other. You look people in the eye, never share anything private, and minutes write themselves.
In-depth guide · 15 min
An explainer with prompts: what it means to let AI run in a loop, what's true in the hype, what's overblown, and how to safely try your first loop.
In-depth guide · 23 min
A complete guide with prompts: Beeper unifies WhatsApp, Messenger, and Slack into one app, and Claude pulls promises and deadlines out of them via MCP on a regular schedule and writes them into Notion. Includes a patient introduction to the terminal for anyone who's never opened one.
You don't have to painfully recall every subscription you're paying for — searching payment confirmations in your inbox plus two system screens puts the list together in ten minutes.
Gaps in your prompt get silently filled with the model's own assumptions. Have them listed out — see what the answer is standing on before you build work on top of it.
Paste an official letter into AI and get four answers: what they want from you, by when, what happens if you don't, and exactly what to do. No legalese, no panic.
Copying a table out of a PDF turns the columns into one tangled noodle of text. Upload the PDF to AI, ask for CSV — and check the control total.
You know the meaning but not the word? Describe it to AI and get ten candidates with the shades of difference between them. Works for technical terms and cliché-free synonyms too.
A forwarded conversation, “see below,” and thirty emails of history. Drop the thread into AI and ask: who's claiming what, where's the agreement, and what are you supposed to do.
Describe in plain words what you want to match, and AI returns a regular expression with a part-by-part explanation and test cases. For Sheets, editors, and bulk edits.
Attendance against sign-ups, payments against orders: paste two lists and AI lists what's in one and missing from the other — even through typos.
AI loves to improve your style, even when nobody asked it to. Tell it to fix only spelling and punctuation and list the changes — your voice stays yours.
An email typed on the wrong keyboard layout or an export from an old system: paste the text into AI and get it back with the accents in the right place. It works in reverse too.
Instead of trawling ten-year-old forum threads, paste the error message — or a screenshot of it — into AI and ask three things: what it means, what to do, and what not to do.
Before you publish, have AI fix only the typography: smart quotes, dashes instead of hyphens, spacing around numbers and units. It leaves the wording alone.
F2
Renaming without a mouse: F2 opens the name for editing, Tab saves it and skips to the next file. Select several files, and they all get renamed at once.
Replace text across all filenames, add a date, number them. PowerRename from PowerToys renames whole batches at once — with a preview before anything actually happens.
Ctrl+Space
What's in that file? Peek from PowerToys shows the contents of a selected file on Ctrl+Space — no waiting for Word, a photo viewer, or a PDF reader to launch.
Win+Ctrl+T
Keep a calculator, notes, or a call always in view: Win+Ctrl+T from PowerToys keeps the selected window above everything else until you unpin it.
Clicking a running app's taskbar icon just brings it to the front. Shift+click opens a new window, Ctrl+Shift+click launches it as admin — three tricks in one icon.
In-depth guide · 26 min
A guide with prompts: a website without hiring a developer — from scaffolding through git as a safety net to a domain and Vercel. Proven on this site.
In-depth guide · 23 min
A guide with prompts: why the agent writes a different script every time, when to move from chat to a file, scheduled runs, and catching silent breaks.
In-depth guide · 24 min
A guide with seventeen prompts: the Meta Ads connector, the official Google Analytics MCP server, both sides combined into one picture — and clear limits.
In-depth guide · 27 min
A complete guide with prompts: how connectors get added, what Buffer, Canva, Notion, or Supabase can really do — and two honest ways to bring in Gemini.
In-depth guide · 27 min
A guide with prompts: why a chatbot silently gets math wrong, how a persistent DuckDB skill lets you query CSV or Excel in plain words — and check results.
In-depth guide · 18 min
A guide with prompts: a style description from your own writing, a living brand book in a Project, one-prompt consistency checks, quarterly reviews.