Controling the Number of Pages in a File

[cos]

Hello,

I'm a novice to Microsoft Excel 2004 (Macintosh) and I know how to use
Page Setup to control the width and height of a page, but wonder if
there's anyway to limit the width of a page to just one page -- so
there's no scroll bar across the bottom allowing you move over to a
second page to the right of the main page?

Similarly I wonder if there's a way to limit the number of pages that a
file can have vertically? By default it seems that a workbook has an
unlimited number of pages that you can keep scrolling down to. Is there
a way to limit it to a specific number of rows, or pages?

Any help on this would be much appreciated.

Thank you,

Cosmas Demetriou

 

[Bob Greenblatt]

Hello,

I'm a novice to Microsoft Excel 2004 (Macintosh) and I know how to use
Page Setup to control the width and height of a page, but wonder if
there's anyway to limit the width of a page to just one page -- so
there's no scroll bar across the bottom allowing you move over to a
second page to the right of the main page?

Similarly I wonder if there's a way to limit the number of pages that a
file can have vertically? By default it seems that a workbook has an
unlimited number of pages that you can keep scrolling down to. Is there
a way to limit it to a specific number of rows, or pages?

Any help on this would be much appreciated.

Thank you,

Cosmas Demetriou

Are you talking about printed pages, or pages visible in page layout view?
In either case, you can always hide the rows and columns that are not
needed.

 

[cos]

Layout view. How does one limit the number of pages horizontally to one
page, and the number of pages vertically to any number you want.
Similarly, can you control the size of the document by specifying a
number of columns horizontally or a number of rows vertically?

I've tried finding this through Help and wasn't able to.

Thanks,

Cosmas Demetriou

 

[Bob Greenblatt]

Layout view. How does one limit the number of pages horizontally to one
page, and the number of pages vertically to any number you want.
Similarly, can you control the size of the document by specifying a
number of columns horizontally or a number of rows vertically?

I've tried finding this through Help and wasn't able to.

Thanks,

Cosmas Demetriou

As I mentioned, you can hide the rows and columns that are not used. There
is no way to change the actual number of rows and columns in a work sheet.
They all have 256 columns and 65536 rows. If you are in page layout view,
just add data to the rows below 53 or so to keep the data vertically. If you
don't want to see the other columns, hide them.

 

[cos]

On 6/20/06 8:16 AM, in article
(e-mail address removed), "cos"

Bob,

I tried hiding the columns to the right of the columns that I want to
keep visible, but it just displays a new set of columns that were to
the right of that. If all spreasheets have 256 columns, and I want to
keep the 10 columns on the left, is there a quick way to select the
others and then going Format/ Columns/ Hide?

Thanks,

Cosmas

 

[Bob Greenblatt]

Bob,

I tried hiding the columns to the right of the columns that I want to
keep visible, but it just displays a new set of columns that were to
the right of that. If all spreasheets have 256 columns, and I want to
keep the 10 columns on the left, is there a quick way to select the
others and then going Format/ Columns/ Hide?

Thanks,

Cosmas

Yes, press F5 and the type in K:IV, or what ever beginning column you need.
Press Return, and then use format/column/hide.

 

[cos]

Bob,

I'm sorry that I'm not getting it. When I type F5 I get a "Go to"
dialogue box. Is this where I should be going? Then I don't understand
the reference you're making below to entering "K:IV or whatever column
you need. Press Return, then Format/ Column/ Hide." I'm lost at the
"K:IV". How is that a column designation? Don't columns have a single
or double letter designation (like G or AC)?

Thank you.

Cosmas Demetriou

 

[Bob Greenblatt]

Bob,

I'm sorry that I'm not getting it. When I type F5 I get a "Go to"
dialogue box. Is this where I should be going? Then I don't understand
the reference you're making below to entering "K:IV or whatever column
you need. Press Return, then Format/ Column/ Hide." I'm lost at the
"K:IV". How is that a column designation? Don't columns have a single
or double letter designation (like G or AC)?

Thank you.

Cosmas Demetriou

Yes, F5 brings up a goto dialog box. If you want all columns beyond J to be
hidden, type "k:iv" (without the quotes. If you want all columns to the
right of column B hidden, type c:iv, etc. This selects those columns. Click
OK and then. Select format-column-hide from the menu. This will hide all the
columns selected in the goto dialog.

Standard Excel notation to define a range uses a colon. So to select (or
refer to columns a and b, the notation is a:b. Column IV is the 256th
column, so k:iv selects columns 11 through 256.

 

[cos]

Thank you so much for the clarification. Is there a similar principle
for rows? What if I want to select all rows beyond 200?

Thank you.

Cosmas

 

[Bob Greenblatt]

Thank you so much for the clarification. Is there a similar principle
for rows? What if I want to select all rows beyond 200?

Thank you.

Cosmas

Just do the same thing for rows. Refer to rows by number. So to hide all
rows beyond row 200 type 201:65536 into the reference box in the go to
dialog.

 

[cos]

Thank you, Bob. It finally worked! Now if I may ask you another
question -- let's say I'm laying out a spreadsheet and I have several
sheets (with tabs at the bottom). I want to make sure that each one of
these sheets fit on an 8-1/2" x 11" piece of paper when printed out. I
can use the procedure we've talked about to hide certain columns and
rows, so I can limit what I see to what I need. However, how do I know
when the number of columns and rows on my sheet fit within the 8-1/2" x
11" size?

Thank you,

Cosmas Demetriou

 

[Bob Greenblatt]

Thank you, Bob. It finally worked! Now if I may ask you another
question -- let's say I'm laying out a spreadsheet and I have several
sheets (with tabs at the bottom). I want to make sure that each one of
these sheets fit on an 8-1/2" x 11" piece of paper when printed out. I
can use the procedure we've talked about to hide certain columns and
rows, so I can limit what I see to what I need. However, how do I know
when the number of columns and rows on my sheet fit within the 8-1/2" x
11" size?

Thank you,

Cosmas Demetriou

Just do the same thing for rows. Refer to rows by number. So to hide all
rows beyond row 200 type 201:65536 into the reference box in the go to
dialog.

There are several ways. First the process we have been talking about is
really unnecessary for this, as Excel will only print the area of the
worksheet which contains data.

Anyway, to get stuff to fit on one page, you should select the worksheet(s)
and go to file-page setup. Set your page geometry and margins. Then, the
area visible (assuming you did not hide any extra rows or columns) will show
in page set up view. If you want to force a whole lot of stuff to fit on
one page, on the page section of the Page setup dialog, click in the fit To
section. If you want one page wide, by several pages deep, for example, put
a 1 in page(s) wide, and make sure the tall section is blank. Check out page
setup in help for more information.

 

[cos]

Bob,

It worked. Thank you,

Cosmas