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.
Category: Formatting
Formatting
Highlight a Whole Row Based on One Cell’s Value in Excel
Highlight an entire row in Excel when one cell says Late, is over a number, or matches a date — one conditional formatting formula and the $ that makes it work.
Formatting
Excel Number Format: currency, thousands separator, decimals, negative in red
Excel number formats explained: currency, comma thousands separator, decimal places, percent, dates, and a custom format with negatives in red.
Formatting
Wrap Text in Excel: show long text on several lines
Wrap text in Excel so long entries show on several lines inside the cell, add a manual line break, and fix rows that will not grow.
Formatting
Excel Alternate Row Color: stripe every other row
Colour alternate rows in Excel two ways: instantly with a Table, or with one conditional formatting formula that survives sorting.
Formatting
Freeze Panes in Excel: keep the heading row in view
Freeze panes in Excel so the heading row (or first column) stays put while you scroll, and how to unfreeze.
Formatting
Conditional Formatting in Excel: colour cells automatically
Conditional formatting in Excel: highlight values over a number, duplicates, top 10, and colour a whole row with a formula.
Formatting
Merge Cells in Excel: the right way (and the trap)
Merge cells in Excel for a heading, unmerge them, and the better alternative — Center Across Selection — that avoids the sorting trap.
8 tutorials · Page 1 of 1
