Page Setup - I need my sheet to be 1 page wide by 1 page t..

AccessNeophyte · External Since: Jun 26, 2007 Posts: 2

Greetings all,

I can't seem to get Page Setup to make my sheet print 1 page wide by 1
page tall, but ALSO >100%. When I select "1 page wide by 1 page tall"
it defaults back to 100%.

BTW, I don't know if this makes a difference, but what I'm trying to
set up is part of a larger spreadsheet, where I've hidden the lines I
don't want to see.

Help?

Thanks,
Liz

FloMM2 · External Since: Sep 14, 2006 Posts: 59

AccessNeophyte,
You could try this:
With the worksheet Open, select View, Page Break preview.
A warning will appear, select "OK".
Then all you have to do is move the dashed lines or solid lines to the edge
of what you want to print.
Good Luck.
hth Smile

"AccessNeophyte" wrote:

> Greetings all,
>
> I can't seem to get Page Setup to make my sheet print 1 page wide by 1
> page tall, but ALSO >100%. When I select "1 page wide by 1 page tall"
> it defaults back to 100%.
>
> BTW, I don't know if this makes a difference, but what I'm trying to
> set up is part of a larger spreadsheet, where I've hidden the lines I
> don't want to see.
>
> Help?
>
> Thanks,
> Liz
>
>

AccessNeophyte · External Since: Jun 26, 2007 Posts: 2

On Jun 29, 3:08 am, FloMM2 <Flo....TakeThisOut@discussions.microsoft.com> wrote:
> AccessNeophyte,
> You could try this:
> With the worksheet Open, select View, Page Break preview.
> A warning will appear, select "OK".
> Then all you have to do is move the dashed lines or solid lines to the edge
> of what you want to print.
> Good Luck.
> hth Smile

>
>
>
> "AccessNeophyte" wrote:
> > Greetings all,
>
> > I can't seem to get Page Setup to make my sheet print 1 page wide by 1
> > page tall, but ALSO >100%. When I select "1 page wide by 1 page tall"
> > it defaults back to 100%.
>
> > BTW, I don't know if this makes a difference, but what I'm trying to
> > set up is part of a larger spreadsheet, where I've hidden the lines I
> > don't want to see.
>
> > Help?
>
> > Thanks,
> > Liz- Hide quoted text -
>
> - Show quoted text -

Sigh...

I wish it were that simple. When I start out, the page breaks are
where I want them. They also get changed when I set it to "1 page
wide by 1 page tall" and it defaults back to 100%.

Darn! Anything else I can try?

Thanks,
Liz