View Only One Page
 

How can I view only the first page of my excel spreadsheet in all the views?
I don't need to see the rest of the rows and columns I'm not using.
Thanks in advance.

Answer: View Only One Page
 

Sure, I can help you with that! Here's how you can view only the first page of your Excel spreadsheet in all views:

1. First, select the cell that is located just below the last row and to the right of the last column that you want to view. For example, if you want to view only the first page of a spreadsheet that has 50 rows and 10 columns, select cell K51.
2. Next, click on the "View" tab in the ribbon at the top of the Excel window.
3. In the "Workbook Views" section of the ribbon, click on the "Page Break Preview" button.
4. You should now see your spreadsheet in Page Break Preview mode. In this mode, you can adjust the page breaks to control which parts of the spreadsheet are visible in each page.
5. To view only the first page of your spreadsheet, click and drag the blue dotted line that represents the bottom of the first page up to the bottom of the last row that you want to view. In our example, you would drag the blue line up to row 50.
6. Once you've adjusted the page breaks to your liking, click on the "Normal" button in the "Workbook Views" section of the ribbon to return to normal view.

That's it! Now you should only see the first page of your spreadsheet in all views. If you need to make changes to the rest of the spreadsheet, you can always switch back to Page Break Preview mode and adjust the page breaks as needed.

View Only One Page
 

Maui Dave wrote:
How can I view only the first page of my excel spreadsheet in all the views?
I don't need to see the rest of the rows and columns I'm not using.
Thanks in advance.

Hide them.

View Only One Page
 

How do I select the rest of the cells to hide? There's an infinite number of
cells past my one sheet

"Gordon" wrote:

Maui Dave wrote:
How can I view only the first page of my excel spreadsheet in all the views?
I don't need to see the rest of the rows and columns I'm not using.
Thanks in advance.

Hide them.

View Only One Page
 

What do you consider a "page"? The viewable window area of a worksheet or
what would be printed on a sheet of paper?

What do you consider a "spreadsheet"? A workbook or a worksheet within a
workbook?

Maybe just hiding the rows and columns you don't to want see on each worksheet
would suffice?

Using VBA you can set the scrolling area of a worksheet so's users cannot move
out of that area.

If interested in that, post back.


Gord Dibben MS Excel MVP


On Sat, 14 Jul 2007 11:38:01 -0700, Maui Dave <Maui
wrote:

How can I view only the first page of my excel spreadsheet in all the views?
I don't need to see the rest of the rows and columns I'm not using.
Thanks in advance.

View Only One Page
 

Select the row below the bottom of data range.

SHIFT + END + DownArrow.

FormatRowsHide

Same for columns to right of data range except use the RightArrow


Other Gord

On Sat, 14 Jul 2007 11:56:03 -0700, Maui Dave
wrote:

How do I select the rest of the cells to hide? There's an infinite number of
cells past my one sheet

"Gordon" wrote:

Maui Dave wrote:
How can I view only the first page of my excel spreadsheet in all the views?
I don't need to see the rest of the rows and columns I'm not using.
Thanks in advance.

Hide them.

View Only One Page
 

Hi,

Do the following:

1. Open the Worksheet .
2. On the Tools menu, click Options.The Options dialog box appears.
3. Click the View tab.
4. Under Window Options, click to select the Page breaks check box.
5. Click Ok to return the Worksheet. Now you can view the page breaks in
your Active worksheet.
6. Click the cloumn header to the right of the first page break and press
Ctrl+Shift+right arrow . This will highlight all the selected columns to the
right. Now right-click and select Hide. All columns are now hidden.
7. Click the row below the bottom first page break and press Ctrl+Shift+down
arrow. This will highlight all selected rows below. Now right-click and
select Hide. All rows are hidden. Now you will view a single page.

Challa Prabhu


"Maui Dave" wrote:

How can I view only the first page of my excel spreadsheet in all the views?
I don't need to see the rest of the rows and columns I'm not using.
Thanks in advance.