 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2007How do I work on one page without seeing other pages
How do I work on one page without seeing other pages on my monitor. I only want to see one page at a time, not multiple pages. Mike What do you mean by one page? As in one worksheet, or as in print layout? > How do I work on one page without seeing other pages on my monitor. I only > want to see one page at a time, not multiple pages. > Mike Just as you would with MS Word it may go to a second page if the first one is full but why does Excel show other pages to the right of the page I am working? When I scroll to the right the page keeps going and going. I do not need all that page, at least not this time? I thought print layout only shows one page but the other pages are still visible. It is not a big deal but I made up a 8-1/2" X 11" time card with Excel and don't need to see all the rest of the stuff. It prints as I expect (1 page) but on screen I just want to see 1 8-12/" X 11" sheet when I open it? Thank for your input Mike > What do you mean by one page? As in one worksheet, or as in print layout? > > > How do I work on one page without seeing other pages on my monitor. I only > > want to see one page at a time, not multiple pages. > > Mike Excel has a great number of columns and rows. 256 columns and 65536 rows in versions 97 through 2003 16384 and 1,000,000+ in version 2007. These cannot be deleted but can be hidden if you don't want to see them. Select all columns and rows you don't like and Format>Column>Hide and Format>Row>Hide. Gord Dibben MS Excel MVP >Just as you would with MS Word it may go to a second page if the first one is >full but why does Excel show other pages to the right of the page I am [quoted text clipped - 13 lines] >> > want to see one page at a time, not multiple pages. >> > Mike It appears that would take quite some time. It is probably not worth doing. I am using 2007. I was looking for more of a one button solution. "Single page worksheet view" or something to that effect. Thanks for your input. > Excel has a great number of columns and rows. > [quoted text clipped - 26 lines] > >> > want to see one page at a time, not multiple pages. > >> > Mike Assuming you want to see just A1:K34 Select col L and SHIFT + End + Rightarrow. Format>Columns>Hide. Select row 35 and SHIFT + End + Downarrow. Format>Rows>Hide. You can do that faster than I typed this post. Gord >It appears that would take quite some time. It is probably not worth doing. I >am using 2007. I was looking for more of a one button solution. "Single page [quoted text clipped - 30 lines] >> >> > want to see one page at a time, not multiple pages. >> >> > Mike Hello Gord, That did it. Taht is exactly what I was after. Thanks very much for sharing your expertise. Mike > Assuming you want to see just A1:K34 > [quoted text clipped - 44 lines] > >> >> > want to see one page at a time, not multiple pages. > >> >> > Mike Glad you hung around. After your previous post I was thinking you had discounted the hiding method and moved on. Gord >Hello Gord, >That did it. Taht is exactly what I was after. Thanks very much for sharing [quoted text clipped - 49 lines] >> >> >> > want to see one page at a time, not multiple pages. >> >> >> > Mike Hi Mike, You can select the cells surrounding your page and set the fill color to white or whatever, best to go a few extra columns and rows past the end of your screen. I like to insert a blank column A and row 1 so that I can run the margin color right around my page. You can also apply borders between your margin and your data. If you don't want the border to print, set your print area one row and column smaller. Another one for visual effect is to hide the row and column headers by going to Tools>Options>View Tab and uncheck row and column headers. If your page fits neatly on one screen you can also zoom in to say 75% then select a cell well off to the bottom right of your page and go to Window>Freeze Panes. When you zoom back to 100% your page won't move with the scroll bars. This is all fiddly little smoke and mirrors type stuff but Excel has never pretended to be a layout program. It's a worksheet program with a bit of formatting capability thrown in. HTH Martin > Just as you would with MS Word it may go to a second page if the first one > is [quoted text clipped - 18 lines] >> > want to see one page at a time, not multiple pages. >> > Mike Hello Martin, Thanks for your input. The previous post answered my question Mike > Hi Mike, > [quoted text clipped - 45 lines] > >> > want to see one page at a time, not multiple pages. > >> > Mike
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.