Data Cleaning
How to Separate Data in a Cell in Excel (names, addresses, codes)
Separate data in one Excel cell into several: by comma or space with Text to Columns, by pattern with Flash Fill, or with TEXTSPLIT — and which to pick.
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
Macros & VBA
How to Open the VBA Editor in Excel (Alt+F11) and find your macro
Open the VBA editor in Excel with Alt+F11 or the Developer tab, find the module holding your recorded macro, read the code, and change one value safely.
Shortcuts
Excel Filter Shortcut: Ctrl+Shift+L and the keys inside the filter
The Excel filter shortcut Ctrl+Shift+L to turn filters on and off, Alt+Down to open a filter menu, keys to search and tick values, and clearing with Alt A C.
Charts
Excel Stacked Bar Chart: parts and totals in one bar
Make an Excel stacked bar chart, show totals on top of each bar, switch to 100% stacked for shares, and know when clustered bars work better.
Print, Share & Protect
How to Insert a Page Break in Excel (and remove or see them)
Insert a manual page break in Excel so each section prints on its own page, see where breaks fall with Page Break Preview, move them, and remove them.
Shortcuts
Excel Merge Cells Shortcut: Alt H M M (and the safer alternative)
The keyboard shortcut to merge cells in Excel (Alt, H, M, M), merge and centre, unmerge, and Center Across Selection which does the same without the problems.
Dates & Times
How to Sort by Date in Excel (and why it sorts wrong)
Sort by date in Excel oldest to newest, keep rows together, sort by month ignoring the year, and fix the sort when dates are stored as text.
Shortcuts
Excel Delete Row Shortcut: Ctrl+Minus, and delete many rows fast
Delete a row in Excel with Shift+Space then Ctrl+Minus, delete several at once, delete every filtered row, and undo.
Print, Share & Protect
How to Add a Header in Excel (printed header, not the heading row)
Add a header in Excel that prints at the top of every page: title, date, file name, page numbers, a logo — and the difference from a heading row.
Showing 190–198 of 294 tutorials · Page 22 of 33
