ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   PRINTING PROBLEM W/EXCEL 2000 (https://www.excelbanter.com/excel-discussion-misc-queries/106633-printing-problem-w-excel-2000-a.html)

cynjor312

PRINTING PROBLEM W/EXCEL 2000
 
I have a table in excel that needs to be printed. The information in the
table stretches across columns A-V. I've gone to page set up and chose
different paper size (legal & 11 x17). In page break view i see that there
are over 60 pages so i moved the border of page 1 all the way to the end
(column V) and it comes out to be 9 pages long. by time i print it out on
either paper (legal or 11 x 17) the font size is very very small and in page
set up it says "scaled to fit 39% of the normal size." Is there any other way
to go about printing this document? I would like to get it so that when i
print you can see all the information from start to end (Col A to V) without
the information breaking up. Thank you in advance!

Dave Peterson

PRINTING PROBLEM W/EXCEL 2000
 
Maybe you can hide some of the columns that aren't important to you?

Or print it smaller pieces.

But use file|page setup|sheet tab|rows to repeat at top and columns to repeat at
left to act as reference points.

I'd also row and column headings--I think it makes reviewing large amounts of
data easier (but it does take up some real estate on the page, too).

cynjor312 wrote:

I have a table in excel that needs to be printed. The information in the
table stretches across columns A-V. I've gone to page set up and chose
different paper size (legal & 11 x17). In page break view i see that there
are over 60 pages so i moved the border of page 1 all the way to the end
(column V) and it comes out to be 9 pages long. by time i print it out on
either paper (legal or 11 x 17) the font size is very very small and in page
set up it says "scaled to fit 39% of the normal size." Is there any other way
to go about printing this document? I would like to get it so that when i
print you can see all the information from start to end (Col A to V) without
the information breaking up. Thank you in advance!


--

Dave Peterson

cynjor312

PRINTING PROBLEM W/EXCEL 2000
 
thanks!. Will try this and let you all know what i come up with.

Cynthia

"Dave Peterson" wrote:

Maybe you can hide some of the columns that aren't important to you?

Or print it smaller pieces.

But use file|page setup|sheet tab|rows to repeat at top and columns to repeat at
left to act as reference points.

I'd also row and column headings--I think it makes reviewing large amounts of
data easier (but it does take up some real estate on the page, too).

cynjor312 wrote:

I have a table in excel that needs to be printed. The information in the
table stretches across columns A-V. I've gone to page set up and chose
different paper size (legal & 11 x17). In page break view i see that there
are over 60 pages so i moved the border of page 1 all the way to the end
(column V) and it comes out to be 9 pages long. by time i print it out on
either paper (legal or 11 x 17) the font size is very very small and in page
set up it says "scaled to fit 39% of the normal size." Is there any other way
to go about printing this document? I would like to get it so that when i
print you can see all the information from start to end (Col A to V) without
the information breaking up. Thank you in advance!


--

Dave Peterson



All times are GMT +1. The time now is 04:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com