Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stopping something printing in Excel 1

Status
Not open for further replies.

JohnnyT

Programmer
Jul 18, 2001
167
GB
Hi,

I have a worksheet that has some information deliberately off the side of the page that will be printed. If I choose to print everything it will print the main page and then print this extra stuff.

I can obviously specifically choose which page(s) to print but wondered if there was some way of selecting some text and marking it as not to be printed?

Many thanks for any help

Cheers

John

I don't make mistakes, I'm merely beta-testing life.
 



Hi,

File > Print Area

Skip,

[glasses] To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white] [tongue]
 
Brilliant Skip thanks!

(and an amazingly quick response!)

I'm using Excel 2007 so its Page Layout - Print Area but it did the job ...

Thanks

JT ;-)

I don't make mistakes, I'm merely beta-testing life.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top