Page Break Preview

[henry]

Is it possible to view a page in page break preview without the larg
Page # in grey interferring with the view

 

[Bill Sharpe]

Is it possible to view a page in page break preview without the large
Page # in grey interferring with the view?

I don't think so. "Page Break Preview" implies that you want to know
which page is where in your worksheet. An ordinary print preview gets
rid of the gray background, but of course you only see one page at a
time. But in normal view your worksheet shows the page breaks as dotted
lines.

Bill

 

[henry]

What I was really wanting to do was save an excel document in a vie
that just had 1 page visible on the screen, like the printed pag
rather than like a spreadsheet just for asthetics really and i though
the page break preview might be teh easiest way to do it, but then ha
the problem of the large grey watermark saying what page number it is
Basically I've set up a birthday list that is easiest to manage i
excel than in word

 

[ScottO]

You might be able to create the visual effect you want by turning off
gridlines & Column/Row headings.
Rgds,
ScottO

message |
| What I was really wanting to do was save an excel document in a
view
| that just had 1 page visible on the screen, like the printed page
| rather than like a spreadsheet just for asthetics really and i
thought
| the page break preview might be teh easiest way to do it, but then
had
| the problem of the large grey watermark saying what page number it
is.
| Basically I've set up a birthday list that is easiest to manage in
| excel than in word.
|
|
| --
| henry
| -------------------------------------------------------------------
-----
| henry's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=23872
| View this thread:
http://www.excelforum.com/showthread.php?threadid=477773
|

 

[Bill Sharpe]

What I was really wanting to do was save an excel document in a view
that just had 1 page visible on the screen, like the printed page
rather than like a spreadsheet just for asthetics really and i thought
the page break preview might be teh easiest way to do it, but then had
the problem of the large grey watermark saying what page number it is.
Basically I've set up a birthday list that is easiest to manage in
excel than in word.

Now that you explained what you wanted to do, how about copying (or
linking) the cells of interest in your spreadsheet to a table in a Word
document?

Bill

 

[henry]

Thankyou for those ideas