What version are you using? This seems to work as you want in Excel 2007.