Tips & tricks

Conditional Formatting: Let Colors Do the Talking

Duplicate values, overdue deadlines, or below-average results highlight themselves — you just define the rule.

Flash Fill: Excel Finishes the Pattern for You

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.

Format as a Table: Filters, Banding, and Formulas for Free

Ctrl+T

Ctrl+T turns a range into a “smart” table — automatic filters, formatting for new rows, and readable formulas.

Block off calendar time for focused work

An empty calendar is an invitation to meetings. Block off your mornings for deep work before someone else does it for you.

F4 in Excel: Repeats Your Last Action and Locks a Reference

F4

One key, two superpowers — repeating your last action and toggling dollar signs in a formula.

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.

The two-minute rule for your inbox

Anything that takes less than two minutes, do right when you read it. Longer things go to your task list — and archive the email.

Stage Manager: one window on stage, the rest wait in the wings

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.

Smart folders: a search that updates itself

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.

Quick edits to PDFs and images without Photoshop

Preview handles arrows, boxes, text, and blurring sensitive info. For 90% of everyday edits, you don't need anything else.

Focus modes: every activity gets its own rules

Set up a Work mode that lets through only colleagues and family — synced to your iPhone and Apple Watch too.

Hide the Dock and reclaim a slice of your screen

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.

Copy on your iPhone, paste on your Mac

Universal Clipboard works between Apple devices automatically — text, photos, and links travel over without emailing yourself.

Copy text right out of images and photos

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.

Quick Finder jumps: Desktop, Applications, Downloads

Cmd+Option+L

Finder has shortcuts for the folders you use most — Cmd+Shift+D for Desktop, Cmd+Option+L for Downloads, and more.

Your iPhone as a scanner: scan a document straight into your Mac

Right-click in Finder → Import from iPhone → Scan Documents. The scan lands directly in the folder, perfectly cropped.

Split View: two apps side by side, full screen

Hold down the green button on a window and pick a half of the screen. Perfect for writing with reference material alongside.

Sign PDFs in Preview — no printer or scanner needed

The Preview app can drop your signature straight into a PDF. Capture it once, then sign in two clicks from then on.

Multiple desktops: separate work from communication

Ctrl+→

Ctrl+arrows switch between virtual desktops. One for focused work, one for mail and chat — and distractions disappear from view.

Hot corners: reveal the desktop or lock your screen with one flick

Assign actions to the corners of your screen — flicking into a corner shows the desktop, starts the screensaver, or locks the screen.

Text replacement: type “addr” and the whole address pops out

macOS can replace short shortcuts with long text system-wide — in email, browser, and chat alike. Set it up once, works everywhere.

Bulk rename files right inside Finder

Select files, right-click, Rename — Finder can replace text, add sequence numbers, and format names with numbering.

Dictation: you talk, your Mac types

Double-tapping the keyboard shortcut starts dictation wherever the cursor is blinking. It handles other languages surprisingly well.

“Cut and paste” files in Finder

Cmd+Option+V

The Mac has no Ctrl+X for files — instead, copy with Cmd+C and paste with Option: the file moves instead of copying.

Spotlight as a calculator and unit converter

Cmd+Space

No need to open a calculator or google an exchange rate. Spotlight calculates and converts currencies and units right in the search field.

Screen recording without installing anything

Cmd+Shift+5

Cmd+Shift+5 opens a panel that handles both screenshots and screen video — including area selection and a timer.

Cmd+Tab: switch apps like a pro

Cmd+Tab

The app switcher can do more than it looks — quit apps, hide them, or switch between windows without ever letting go of the keys.