Hi again all.
Sorry none of those get arounds are a cure, just a get around, there are several but it always comes back once you have it in a sheet or book. You just can't use page layout view to lay out pages!!!!!!!!!!!
MS NEEDS to sort it, it's gone on long enough and through different versions of Excel.
We all need to keep mentioning it on forums like this or it'll never be sorted properly.
I'm on 2010 now and need to do some work with it, dreading it as I know it'll be there at some point and you just can't lay out a page easily if you're not in page layout view, need to keep flicking back and forth.
So please don't refer to a get around as a cure as it's not.