Data Cleaning
Convert Text to Number in Excel: 4 ways, fastest first
Convert text to numbers in Excel: the green-triangle button, Paste Special multiply, VALUE, and Text to Columns — and how to tell text from numbers.
Author: Srini Vanamala
Print, Share & Protect
How to Print Labels from Excel (with Word mail merge)
Print address labels from an Excel list using Word's mail merge: set up the sheet, pick the label size, map the columns, preview and print.
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.
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.
152 tutorials · Page 8 of 17
