Category: Excel User tips

Paste Special Percentage

Spreadsheet Compare application

Excel @ before function names in formulas

Comments versus Notes

Shapes with dynamic output

The Excel “&” bug

CTRL+Y a mini macro

Formula Beautifier

Blank (isempty) VS “” (null string)

Excel keeps converting all cells to “Date” (or Time)

When Excel functions are not enough