Someone’s talking G(r)eek again 
Seriously, I get that macros do a lot to automate things in Excel, even if I do not have the expertise or inclination to do so myself.
But all too often ‘use a macro’ is shown as a fix for things that should not need fixing but do and which should be fixed in the application itself. An application that cannot do some of the simple things noted in this thread without the user having to learn how to write and use a macro leaves a lot to be desired. Macros having to be invented as work-arounds by users is a terrible advert for said application’s usability. @cannibalpeas is right to note how spine-shudderingly frustrating it is to read that the answer to your problem is…
