If something is driving you nuts, ask on a forum, because excel is EXTREMELY flexible and used in some pretty high volume environments and the original developers really paid attention to user input (for a long while that stopped).
In many cases you are just not fully up to speed with the features in windows / excel.
In many cases you are just not fully up to speed with the features in windows / excel.