i know how to get round it by selecting visible cells only, however i want to set it to default.. as this should be the case with execl 2007 and is for every pc at work except my other one for some reason... exactly the same specs so im not sure whats happened - thinking maybe there is a button in options somewhere but i was unable to find it.