Formatting
Wrap Text in Excel: show long text on several lines
Wrap text in Excel so long entries show on several lines inside the cell, add a manual line break, and fix rows that will not grow.
Author: Srini Vanamala
Formatting
Excel Alternate Row Color: stripe every other row
Colour alternate rows in Excel two ways: instantly with a Table, or with one conditional formatting formula that survives sorting.
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.
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.
152 tutorials · Page 14 of 17
