Good question sms - one I've asked many times and never found the answer! In 8 years of Excel use at work, I've never managed it - I usually resort to either deleting all extra rows (normally 60k+) and all extra columns (last is IV). That, or I grey the additional rows and columns, remove the row and column headers and protect the sheet. Both methods I consider "cheating" but the result is much more usable and pleasing to the eye.
Anyone else know anything more professional??