Print Areas in Excel

963 Views 8 Replies 3 Participants Last post by XL Guru, Mar 29, 2004

cchalmers

Discussion Starter · Mar 25, 2004

If I have a sheet in Excel and want to print out say a section in Row one and then a section in Row four, I know I can highlight the first area I want to print and then set the print area and then add to that print area but when it actually prints out it always prints on two pages. Is there anyway of forcing it to consolidate on to one page!? Or is there another method of being able to print two separate sections of a sheet on to one page......

Any ideas appreciated!

Save

Status: Not open for further replies.

1 - 4 of 9 Posts

XL Guru

· #2 · Mar 25, 2004

This is not something I've ever looked at.

To start with, what do you mean by "sections"? Hiding rows &/or columns will prevent them from printing.

Rgds,
Andy

Save

XL Guru

· #4 · Mar 25, 2004

>> hope this gives you a better explanation

Yes. :up:

Check out (Views --) Custom Views.

And/or Report Manager (this is an add-in, you may need to check Tools -- Add-Ins).

Rgds,
Andy

Save

XL Guru

· #6 · Mar 25, 2004

Thanks itsmeitsmeitsme ; I always forget CopyPicture (but then I forget so many things

).

Just for info tho',

"note that holding down Alt and Shift and using the mouse to click 'Edit' on the menu does NOT work i.e. you HAVE to use the 'E' on the keyboard"

is wrong ; once the range is selected, you CAN just hold down Shift & then click on Edit. At least in XL2K.

Rgds,
Andy

Save

XL Guru

· #9 · Mar 29, 2004

>> cool tool!!

OK. In that case the Camera tool may also interest you, since it pastes a linked picture (i.e. changes to the copied area automatically update in the pasted picture).

To try it out, rightclick the menu bar and choose Customize. Then follow the screenshot.

Rgds,
Andy

See less See more

Save

1 - 4 of 9 Posts

Status: Not open for further replies.

Print Areas in Excel

cchalmers

XL Guru

XL Guru

XL Guru

XL Guru

Attachments

Top Contributors this Month