How to Insert a Checkbox in Excel (2026)
Add checkboxes in Excel two ways: the new built-in Checkbox button in Microsoft 365, and the classic Developer-tab form control — plus how to link a checkbox to a cell and copy it down.
Page 109 of 138
Add checkboxes in Excel two ways: the new built-in Checkbox button in Microsoft 365, and the classic Developer-tab form control — plus how to link a checkbox to a cell and copy it down.
Lock specific cells in Excel so they can't be edited: why locking needs sheet protection, how to unlock the cells people should still fill in, and how to protect and unprotect the sheet.
Merge cells in Excel with Merge & Center, Merge Across, and Merge Cells — plus how to unmerge, keep all your data, and use Center Across Selection as a safer alternative.
Password protect an Excel file with Encrypt with Password, set a separate password to open vs. modify, protect the workbook structure or a single sheet, and remove a password you no longer need.
Delete blank rows in Excel the safe way: use Go To Special to select blanks, filter them out, or sort them to the bottom — without deleting rows that only look empty.
Remove duplicate rows in Excel with the Remove Duplicates tool, find them first with conditional formatting, dedupe by specific columns, or extract a unique list with the UNIQUE function.
Unhide columns in Excel by right-clicking, unhide column A with the Name Box, unhide all columns at once, and fix columns that won't reappear because their width is zero.
Use conditional formatting in Excel to highlight cells by rule: highlight values, top/bottom items, data bars and color scales, formula-based rules, and how to manage or clear them.
Learn INDEX MATCH in Excel: how the two functions work together, why it beats VLOOKUP, looking left, a two-way lookup with two MATCH functions, and error fixes.
Learn SUMIF in Excel: the syntax, text and number criteria, comparison operators, wildcards, summing a different column, and SUMIFS for multiple conditions.
Learn the IF function in Excel: the syntax, text and number tests, nested IFs, the IFS function, combining IF with AND and OR, and how to fix common errors.
Learn VLOOKUP in Excel step by step: the syntax, exact vs. approximate match, looking up data from another sheet, anchoring the range, and how to fix #N/A and #REF errors.
Learn XLOOKUP in Excel: the syntax, exact and approximate match, looking left, returning multiple columns, the built-in if_not_found argument, and how it beats VLOOKUP.
Wrap text in Excel so long entries show on multiple lines inside one cell: the Wrap Text button, manual line breaks with Alt+Enter, adjusting row height, and common fixes.
How long a Google Meet can run on free and paid accounts — the 60-minute group-call cap, the 24-hour limits, and how to get around them.
Blur your background in Microsoft Teams before or during a meeting on desktop and mobile — plus what to do when the blur or background-effects option is missing.
Blur your background, add a virtual background, or apply a filter in Google Meet — before you join or mid-call, on desktop and mobile.
Change your background in Microsoft Teams — pick a built-in image, upload your own custom background, or blur it — before or during a meeting, on desktop and mobile.
Change your display name in Microsoft Teams — set a name when joining as a guest, edit it on a personal account, or get a work-account name changed through your admin.
Create a poll in Microsoft Teams — live in a meeting with the Polls app or ahead of time in a chat — launch it, share results, and fix a missing poll option.
Turn on transcription in Google Meet to save a Google Doc of who said what, where the transcript saves in Drive, and how it differs from live captions.
Mute and unmute yourself in Microsoft Teams, use the keyboard shortcut and push-to-talk, and — as an organizer — mute other participants or stop them from unmuting.
Pin a participant's video in Microsoft Teams so they stay on your screen, understand pin vs. spotlight, and do it on desktop and mobile — plus how to unpin.
Raise your hand in a Microsoft Teams meeting on desktop, mobile, and with a keyboard shortcut — plus how to lower it and see who else has raised theirs.