Shortcuts
Excel Strikethrough Shortcut: Ctrl+5 (and strike through automatically)
Strikethrough in Excel with Ctrl+5, remove it, strike through part of a cell, and strike through done tasks automatically with conditional formatting.
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
Formatting
How to AutoFit Columns in Excel: every column the right width
AutoFit columns in Excel with a double-click, the whole sheet in one go, the keyboard shortcut, and why long text and merged cells stop it working.
Excel Basics
How to Add Columns in Excel: insert one, several, or between every column
Add a column in Excel with right-click or Ctrl+Shift+Plus, insert several at once, add one at the end of a table, and undo if it went in the wrong place.
Excel Basics
How to Insert a Checkbox in Excel (and count the ticks)
Insert a checkbox in Excel — the one-click way in Excel 365, the Developer-tab way in older versions, link it to a cell, and count how many are ticked.
Macros & VBA
Excel Macros: what they are and your first one in 5 minutes
Excel macros explained without jargon: what a macro is, when to use one, how to record your first, run it, and keep it safe.
Excel Basics
How to Hide Columns in Excel (and unhide them later)
Hide columns in Excel with a right-click or Ctrl+0, hide several at once, unhide them, and use Group instead when you hide and show often.
Excel Basics
How to Unhide All Rows in Excel (and columns) in one go
Unhide all rows in Excel with select-all and one shortcut, unhide columns the same way, and fix rows that stay hidden because of a filter or zero height.
Excel Basics
How to Move a Column in Excel (without overwriting anything)
How to move a column in Excel: the Shift-drag method that inserts instead of overwriting, cut and insert, and swapping two columns.
Formulas & Functions
How to Use VLOOKUP in Excel: a beginner’s walkthrough
How to use VLOOKUP in Excel from a blank sheet: build the lookup table, write the formula piece by piece, copy it down, and fix #N/A.
Showing 208–216 of 294 tutorials · Page 24 of 33
