Quote:
Originally Posted by macropod
All you have to do is to follow the instructions given in the post. The macro works automatically in the background.
The macro is for Word, not Excel; this is a Word forum, after all.
Excel does not have a page metaphor - it's simply a huge grid that can (but doesn't have to) be broken up into pages. It seems your expectations re Excel misunderstand this. Of course, if you only want to see the equivalent of a page, you could reduce the Excel window size instead of zooming - or you could hide all the columns (and/or rows) outside of what you want to view.
|
Thank you. I will try to find a friend to show me where to begin with the macro instruction.
But with all due respect, hiding the columns does not change or fix the issue in any way. If I am working only in columns A through F, and the page break between F and G runs right down the middle of my screen, and I hide columns G through U, then columns V through AD simply now show on the page 2 where columns G through U were. No matter how many columns I hide, I will still have the page break running right down the middle of my screen, so that everything I am working on on page one is on the left side of my screen, and a blank page 2 is still taking the entire right side of my screen. If Excel can give us page breaks and various layout options and fancy formatting, I'm fairly sure it is not too much to ask a normal size window simply show us only the page we are working on. Having to zoom and reduce the window size and use a magnifying glass everytime we open a document just doesn't seem reasonable.
Does anyone know if other versions do not have this issue?
Many thanks, the expertise and free advice is truly a wonderful thing to have access to. Thank you.