Excel Size

[Solkeys]

I got an file in Excel that has 18 columns but when I want to print it and
can't fit all the columns. What can I do to decrease the size it should fit
in?
Solomon

 

[Gordon]

I got an file in Excel that has 18 columns but when I want to print it and
can't fit all the columns. What can I do to decrease the size it should fit
in?
Solomon

File-Page Setup-Page and click "Fit to"

 

[Solkeys]

Thank You very much for your reply.I did as you suggested but it came out so
tiny that it can not be read. It printed only four inches wide.
Solomon

 

[Gordon]

Thank You very much for your reply.I did as you suggested but it came out so
tiny that it can not be read. It printed only four inches wide.
Solomon

Landscape instead of Portrait?

 

[Solkeys]

This way it squished into 3 inches.
Solomon

out

Landscape instead of Portrait?

 

[Gordon]

This way it squished into 3 inches.
Solomon
print

Then you will have to accept that you cannot print it all on one page. In
File-Page Setup-Page set the orientation to Landscape and then set the
scaling to fit to one page wide by two or more pages tall. You'll have to
play with it until you get the optimum width with the minimum number of
pages.

 

[Solkeys]

I am wondering is it possible the reason this is happing is because even
though 18 columns are used there are much more columns there?
Solomon

 

[Gordon]

I am wondering is it possible the reason this is happing is because even
though 18 columns are used there are much more columns there?
Solomon

Have you set the print area?

File-Page Setup-Sheet and select the Print Area

 

[Solkeys]

No.How do I do it?
Solomon

Have you set the print area?

File-Page Setup-Sheet and select the Print Area

 

[Gordon]

No.How do I do it?

File-Page Setup-Sheet and select the Print Area. Click on the box at the
right hand end of the area field and then select the area to be printed.

 

[Solkeys]

Don't I have to type something into that space?
Solomon

 

[Gordon]

Don't I have to type something into that space?
Solomon

You can either type the area in, in the format "A1:Z18" (or whatever your
area actually is, without the quotes), or, click on the little box at the
right hand side of the space, and, using your mouse, select the print area.
That will automatically fill the box for you.