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.
All tutorials
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.
Charts
How to Create a Chart in Excel: the 5-step method for any chart
How to create a chart in Excel: arrange the data, select it, pick the chart type that fits, then title, label and tidy — the same five steps for every chart.
Charts
Excel Bar Chart: make one, sort the bars, and label them
Make an Excel bar chart in four steps, put the biggest bar on top, add data labels, change the colour of one bar, and choose bar vs column.
Dates & Times
Excel Date Format: change how dates look, and fix dates that won’t change
Change the date format in Excel — dd/mm/yyyy, 29 Sep 2026, day names — with Ctrl+1 and custom codes, and fix dates that refuse to change because they are text.
Formatting
How to Lock the Top Row in Excel so it stays while you scroll
Lock the top row in Excel with Freeze Top Row, lock two rows or a column too, and the difference between locking for scrolling and locking for editing.
Formulas & Functions
How to Count Cells with Text in Excel (any text, or specific text)
Count cells that contain any text in Excel with COUNTIF and a wildcard, count cells with specific text, and count non-empty cells including numbers.
Dates & Times
How to Make a Calendar in Excel (monthly, with formulas)
Make a monthly calendar in Excel that rebuilds itself when you change the month: one date cell, one formula, conditional formatting for today.
Pivot Tables & Tables
How to Make a Table in Excel: from a blank sheet to a proper table
How to make a table in Excel from scratch: type the headings, enter data, press Ctrl+T, then sort, filter, total and style it.
152 tutorials · Page 7 of 17
