Print all columns - Excel 2007- How?

[Joe727]

Hi - I have a simple mileage/tracking reimbursement Excel 2007 spreadsheet
with 9 columns (A through I).

Here's a screenshot:

http://home.cfl.rr.com/jbmsbink/Excelmileage.jpg

For some reason, I can only print columns B through F even in Landscape
mode.

Question: How do I get all of the columns to print?

Thanks

Joe (an Excel noob)

 

[Bernard Liengme]

You may need to set the Print Area from the PageSetUp tab
best wishes

 

[Joe727]

Hello Bernard - thanks for the quick reply. I found the tab you are
referring to, but when I try to set the printing areas, I get a pop-up
dialog box stating I only selected one cell.

Question 2 - How do I select the entire Excel spreadsheet?

Joe

 

[Bernard Liengme]

You must select all the cells you want printed, then use the Ribbon to set
the print area
best wishes

 

[Joe727]

Hi - I used Control A to select the entire spreadsheet and then set the
print area.

The entire document printed but not in a usable format.

Here's a scan of what printed:

http://home.roadrunner.com/~jbmsbink/Excelprint.jpg

Joe

 

[Bernard Liengme]

There is an Excel setting where by you can have the worksheet printed on N
by M pages (you get to set the values of N and M). Just uncheck this feature
in PageSetUp
best wishes

 

[MikeJohnB]

The setting can be found on page setup. Fit to X Pages wide by Y Pages tall.

Try this setting starting with 1 page wide by 4 pages tall and see what the
result is, then change according to the look of the printout.

 

[Joe727]

Bernard and Mike:

I am almost there. As you can see by this screen shot I am only missing
columns H & I (column I (eye) is essentially a border column).

http://home.roadrunner.com/~jbmsbink/Excelprint2.jpg

I tried the settings that Mike recommended, but did not quite get the
desired result. So, I set the Width and Height to Automatic. This allowed
me to set the scale to 100%.

The Scale Setting stayed grayed-out until I set the height and width to
automatic.

For some reason, there is a vertical dotted line between columns G and H.

I am not sure why that dotted line is there or how it got there.

I seems that if I remove/move that dotted line, I'll be able to print the
entire spreadsheet.

Question 5: How do I remove/move that dotted line, I'll be able to print
the entire spreadsheet which includes columns A through I (eye)?

Thanks again,

Joe

 

[MikeJohnB]

The dotted line between columns G and H is showing your print area. You need
to drag over the area that you want as the print area then press set print
area. I suggest you dont need the columns A and I, as you can adjust the
width of the boarders in Page Set up. or Margins again on the ribbon you have
displayed. To select the area, place your cursor in cell B2, you will see
that there is a little dot on the right lower quadrant of the cell, put your
cursor on that click and hold, drag to the full extent of the data and
release. Press the print area icon and select set print area.

Check also the page set up, you may need to change the width of the existing
boarders, reduce them so that the data fits the page and looks that way you
want it to.

Hope this helps, cant stay longer, on my way to work.

Kindest regards

 

[MikeJohnB]

Now at work, spend all day on spreadsheets and databases.

Another thing you can do is to close up the cell widths which will allow the
same data to be spread over a smaller sheet. Select the whole column by
clicking on the column header row. place your cursor on the right hand edge
of the header cell, you will see the cursor change to two horizontal arrows
and centre line. doulble click. The column contents will shrink to fit the
widest entry. This works but only for columns tha are not part of merged
cells.

I presume your headers are not merged because you have placed your note in
the top header. If they are, you can unmerge them and size the column
followed by re-merging the headers.

Hope this helps????

Regards

Mike B

 

[Joe727]

<snip to place here> Now at work, spend all day on spreadsheets and
databases.<end snip to place here>

Mike - there's a special place in heaven for you -

Thanks for your help.

I finally figured out how to print the *full* spreadsheet thanks to your,
and others' help.

I really appreciate you taking your time to help me.

BTW, Excel 2007 is the first experience I've had with spreadsheets, and it's
been pleasant thanks to this community.

If I have any more questions, rest assured, I'll be posting them here.

Joe