Excel: Ctrl+Arrow Keys Jump to the Edge of Your Data
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.
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+↓
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.
Search operators find in seconds an email you'd otherwise spend fifteen minutes hunting for by hand.
An automatic rule moves newsletters under a label and marks them as read. You read them when you want to.
Answering similar questions over and over? Save the reply as a template and drop it in with two clicks.
The Snooze feature hides an email from your inbox and brings it back at a time you choose. Your inbox stays clean and nothing gets lost.
An email written Saturday evening can go out Monday at 8 AM. Scheduled sending respects the recipient's time — and your reputation.
Two profiles means two sets of bookmarks, logins, history, and extensions. No more signing out and mixing work with personal.
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.
An alternative to window-switching — the active window sits center stage, the rest lined up at the edge. Helps you keep one thing in focus.
Save a search as a smart folder — say, “PDFs from the last week.” The contents keep themselves up to date by the rules you set.
Preview handles arrows, boxes, text, and blurring sensitive info. For 90% of everyday edits, you don't need anything else.
Set up a Work mode that lets through only colleagues and family — synced to your iPhone and Apple Watch too.
Cmd+Option+D
Cmd+Option+D hides the Dock. On a laptop that gets you a noticeable strip of extra screen — the Dock slides out only when you want it.
Universal Clipboard works between Apple devices automatically — text, photos, and links travel over without emailing yourself.
macOS can select text in a photo or screenshot just like regular text. Grab a phone number off a photo of a business card in two clicks.
Cmd+Option+L
Finder has shortcuts for the folders you use most — Cmd+Shift+D for Desktop, Cmd+Option+L for Downloads, and more.
Right-click in Finder → Import from iPhone → Scan Documents. The scan lands directly in the folder, perfectly cropped.
Hold down the green button on a window and pick a half of the screen. Perfect for writing with reference material alongside.
The Preview app can drop your signature straight into a PDF. Capture it once, then sign in two clicks from then on.
Ctrl+→
Ctrl+arrows switch between virtual desktops. One for focused work, one for mail and chat — and distractions disappear from view.
Assign actions to the corners of your screen — flicking into a corner shows the desktop, starts the screensaver, or locks the screen.