I've never seen Excel behave as you describe.