Formulas & Functions
COUNTIF Greater Than (and Less Than) in Excel
Count cells greater than or less than a number, a cell value or a date with COUNTIF — including the quote-and-ampersand rule that trips everyone up.
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
How to Remove a Password from Excel (when you know it)
Remove the open password from an Excel file, unprotect a sheet or workbook structure, and remove a read-only password — all require knowing the current password.
Fixes & Errors
#SPILL! Error in Excel: what it means and how to fix it
#SPILL! means a formula's results can't spread into the cells they need. Clear the blocking cells, unmerge, move out of a table, or return a single value with @.
Fixes & Errors
Excel SUM Not Working? Why it shows 0 or the wrong total
SUM returning 0, not updating, or ignoring some cells? Numbers stored as text, manual calculation, hidden spaces and circular references are the usual causes. Fixes for each.
Fixes & Errors
Excel Filter Not Working? 7 fixes
Filter missing rows, greyed out, or showing wrong results? The usual causes are blank rows, a partial selection, text-stored numbers, merged cells or a protected sheet.
Fixes & Errors
Excel Protected View: what it is and how to turn it off
Why files from email and the internet open read-only in Protected View, how to enable editing safely, and how to stop Protected View for trusted folders.
Print, Share & Protect
Excel Print Preview: check before you print
Open Print Preview with Ctrl+P or Ctrl+F2, fit the sheet on one page, fix cut-off columns, and add a one-click Print Preview button.
Fixes & Errors
Scroll Lock in Excel: turn it off (arrow keys move the sheet)
If the arrow keys scroll the whole sheet instead of moving the cell, Scroll Lock is on. Turn it off from the keyboard, the on-screen keyboard, or a Mac shortcut.
Excel Basics
Excel Split Screen: see two parts of a sheet (or two files) at once
Split one worksheet into two or four scrolling panes with View › Split, open the same file in two windows, and put two workbooks side by side.
Showing 37–45 of 294 tutorials · Page 5 of 33
