Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-25-2012, 06:32 PM
macropod's Avatar
macropod macropod is offline How do you view a single page Windows 7 64bit How do you view a single page Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,527
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Litsa2020 View Post
I'm afraid the macro is a bit advanced for me. Is the Word macro applicable to Excel? I have found that when I zoom with the slider to 159 it gets close to showing the one page only. But this is fairly clumsy to have to mess with each time I work on any Excel document (which is all day). If I should proceed with the macro, I would need further help with how to do that....


Thank you!!
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 04-26-2012, 01:00 PM
Litsa2020 Litsa2020 is offline How do you view a single page Windows Vista How do you view a single page Office 2007
Novice
 
Join Date: Apr 2012
Posts: 4
Litsa2020 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't move to next page in print layout view ksveren Word 2 02-04-2010 03:15 AM
How do you view a single page Different alignments in a single line George99 Word 2 01-24-2010 05:49 PM
multiple colums under a single column RobotChicken Excel 3 01-06-2010 09:17 AM
How do you view a single page Single Space on Enter? crackinthekraken Word 4 12-09-2009 11:01 AM
Hyperlink on a single chart element jerh PowerPoint 0 09-14-2009 10:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft