Excel Shortcut: Add Date or Time to Cell

To quickly add current date to active cell press CTRL + SEMICOLON (i.e. CTRL + ; )

To add current time press CTRL + COLON (i.e. CTRL + : )

VBA: Remove All Shapes From Sheet

To remove all shapes from a sheet, use the below snippet:

Sub RemoveShapes()


    Dim s As Shape


    For Each s In ActiveSheet.Shapes
        s.Delete
    Next s


End Sub

Excel: Count Unique (Number) Values

To count the unique number values in a range, say for example column A, you can use a combination of SUM, IF and FREQUENCY formulas.

Example:
=SUM(IF(FREQUENCY(A:A;A:A)>0;1))


Check the help for more details on FREQUENCY formula.

Excel: How to Repair a Corrupted Workbook (Excel 2002, Excel 2003)

Read Microsoft's tips how to repair a corrupted workbook. For Excel 2002 and Excel 2003.

Excel: How to Repair a Corrupted Workbook (Excel 2007, Excel 2010)

Read Microsoft's tips how to repair a corrupted workbook. For Excel 2007 and Excel 2010.

Contextures: When Good Excel Macros Go Bad

"It worked yesterday..." Ever recall using this sentence when working with your Excel and macros? Even worse, saying this to your boss when he's looking your cool Excel dashboard you just sent him.

Check the post When Good Excel Macros Go Bad from Debra Dalgleish @ Contextures for one similar journey - and how she fixed it!

Excel Shortcut: Open Save As.. Dialog

To open the Save As... dialog press F12