Microsoft Excel, printing a certain area??

Rossy_3

I am trying to print several different rows from Microsoft Excel. I've selected the area I want to print, selected 'file, print area, set print area', but it puts the rows on separate pages? I want these rows printed on one page?

Then I tried 'file, print, selection', this also puts it unto several pages. I'm looking for these rows to print on one page??

Whitefiver

Hi,

I think if you highlight the intervening rows, right click on one of them and select hide (or something like), the you can probably do what you want.

Regards,

White

Rossy_3

Hi Whitefiver

Tried that, didn't seem to work, still prints on several pages. When I select 2 rows together it prints that on one page, then when I select other rows it prints them in a separate page!

I was wanting to print the area I highlighted unto one page!

Thanks

Rossy

Bossyboots

Are you sure your document is not more than one page?

Go to print preview/options/fit to 1 page and it should work.

Chippy_Minton

If a print area contains nonadjacent areas of a worksheet, Excel prints each area on a separate page by default.

To get around this, select the rows you don't want to print and hide them (Format menu - Row - Hide). Then set a print area that contains all the rows, including the hidden rows.

Rossy_3

This is something I'm trying out at home as I had to do it in work today, its on one page. I've just typed a few rows in excel and for work I need to print out certain rows. So for eg. if I want to print row 2, 5, 6, 10 it prints row 2 on one page, row 5 & 6 unto another page, then row 10 on a third page.

Trying to get these to print on one page??

Rossy_3

Chippy_Minton, you've got it!! Thanks a million, hopefully I'll have a better day at work tomorrow.

You were right too Whitefiver, just couldn't get my head around it.

Cheers

Rossy