Wizard’s tips by email
Search this site
TagsACOS ADDRESS Chart COLUMN CONCATENATE Conditional format COS COUNTA COUNTIF Custom View Dates Dropdown Format Formulae Frequency IF INDIRECT LARGE MAX MID MOD Named ranges Navigation OFFSET Paste Special Percentages PivotTable PivotTables PRODUCT RADIANS RAND RANK Reference Ribbons ROUND ROUNDDOWN Shortcut Sorting Sudoku SUM SUMIF Syntax Text to columns Trigonometry VLOOKUP
Tag Archives: Format
Some neat Excel custom formats A few nice custom Excel formats for you to use. <;;;> Stores a value, but doesn’t display it <00000> Always stores five digits. So 453 becomes 00453. Useful for US zip codes <[Black] General> To … Continue reading
If you want to hide the contents of a cell, instead of matching its font colour with its background, give it a custom number format of ";;;" (without the quotes). It's more elegant and won't suddenly appear if the background … Continue reading
CTRL+1 is a very useful shortcut to bring up the Format Cells dialog box.