Printing Columns on Same Page


I

iamnu

I have a sheet with 5 rows and 100 columns of data, and I want to
print them in Portrait View.

I would like the first 10 columns to print on page 1, followed by the
second 10 columns on page 1, followed by the second 10 columns on page
1, etc...until there is no more room on the physical page, in which
case, it will break and continue printing the remaining columns as
described above on the next page (2), etc.

If this is possible, how is it done?
 
Ad

Advertisements

R

RBear3

If you change to the "page break view" you can adjust your page breaks
easily on the screen.

View --> Page Break Preview
 
I

iamnu

If you change to the "page break view" you can adjust your page breaks
easily on the screen.

View --> Page Break Preview

--
Hope that helps!

RBear3
.

I gave that a thought, but when I look at the Page Break Preview, I
see the columns in a horizontal line, with a dark blue line around
those that would appear on page 1, page 2, page 3, etc. I don't see
how, or where the page breaks are located in order to adjust them as
you suggest.
 
B

Bob I

iamnu said:
I gave that a thought, but when I look at the Page Break Preview, I
see the columns in a horizontal line, with a dark blue line around
those that would appear on page 1, page 2, page 3, etc. I don't see
how, or where the page breaks are located in order to adjust them as
you suggest.

Place the cursor on the blue dotted line, drag that line.
 
Ad

Advertisements

I

iamnu

Then place the cursor on the "solid bold blue line", drag that line.

I've moved the lines every which way. I succeed in eliminating some
columns, but not moving them below page one.
 
G

Gord Dibben

You cannot do what you want just by moving pagebreaks around.

You must move the data 10 cols and 5 rows at a time and paste below to get a 10
column, 50 row block of data.


Gord Dibben MS Excel MVP
 
Ad

Advertisements

I

iamnu

You cannot do what you want just by moving pagebreaks around.

You must move the data 10 cols and 5 rows at a time and paste below to get a 10
column, 50 row block of data.

Gord Dibben  MS Excel MVP

Thank you Gord!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top