Print, Share & Protect
Password Protect an Excel File: so it cannot be opened
Password protect an Excel file so nobody can open it without the password, set a separate edit password, and remove the password later.
Learn Excel the easy way.
Short, plain-English tutorials on formulas, shortcuts, charts and everyday Excel tasks. No jargon. One idea per post.
Start here Get Daily One LessonLatest tutorials
Print, Share & Protect
Unprotect a Sheet in Excel (with or without the password)
Unprotect an Excel sheet in two clicks when you know the password, what to do when you don't, and the difference from workbook protection.
Data Cleaning
Split a Cell in Excel: one column into two
Split a cell in Excel: full names into first and last with Text to Columns, or the instant Flash Fill trick, plus TEXTSPLIT for newer Excel.
Dates & Times
Excel Days Between Dates: subtract, or count working days only
Count days between two dates in Excel by subtracting them, count only working days with NETWORKDAYS, and fix the result that shows as a date.
Dates & Times
Excel DATEDIF: years, months or days between two dates
Excel DATEDIF explained: the hidden function that gives full years, months or days between two dates — ages, service length, contract terms.
Dates & Times
Excel TODAY Function: today’s date that updates itself
The Excel TODAY function: insert a date that updates every day, count days until a deadline, and the shortcut for a date that never changes.
Formulas & Functions
TEXTJOIN in Excel: join a whole column with commas
TEXTJOIN in Excel joins a range of cells with any separator and skips blanks — the one-formula way to make a comma list.
Data Cleaning
Find and Replace in Excel: fix a word everywhere at once
Find and replace in Excel with Ctrl+H: change a word across the sheet, replace in a selection only, and remove characters by replacing with nothing.
Print, Share & Protect
Lock Cells in Excel: protect formulas, let people type elsewhere
Lock cells in Excel so formulas cannot be edited while input cells stay open — the two-step method that catches everyone out.
Showing 262–270 of 294 tutorials · Page 30 of 33
