The easiest way is to type B2:H260 into the name box to the left of the
formula bar.
Another option is Edit/ GoTo, & type B2:H260
--
David Biddulph

"Joe727" wrote in message
...
Hi Mike - It looks like I am getting close - lol.

Question 4 - Exactly how do I 'select the range' B2:H260?

BTW: I've spent several hours combing through Microsoft's help file.
Sadly for me, the Help File is not geared toward Excel noobs.

Joe

"Mike Middleton" wrote in message
...
Joe727 -

I'd do something like this:

Select the range you want to print. It looks like approximately B2:H260.
With that range selected, choose Page Layout | Print Area | Set Print
Area.

Choose Office Button | Print | Print Preview Page Setup | Page. Or,
choose Page Layout | Print Titles | Page. In the Scaling section click
the "Fit to:" button, enter 1 for "page(s) wide," and clear the entry for
"tall." (If there's an entry in the "tall" edit box, select it and press
the Delete key. Then click OK.

Now it's probably ready to be printed.

If you want rows 4 and 5 to appear at the top of each page, choose Page
Layout | Print Titles | Sheet, enter 4:5 in the "Rows to repeat at top:"
edit box, and click OK.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"Joe727" wrote in message
...
I used Control A to select the entire image. It printed, but it's all,
for lack of a better description, 'squished up'.

Here's a scan of the printed document.

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

Question 3 - How do I fix this?

Thanks again.

Joe

"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com"
wrote in message
...
By default Excel prints the whole sheet (area which has been used) so
you
really do not need to set the print area..

If you have to set then either select the cells you want to print or
press
Ctrl-A to select the whole sheet..

"Joe727" wrote:

Sheeloo - thanks for the fast reply.

I cleared the printing area, 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 (set) the entire Excel spreadsheet?

Joe

"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com"
wrote in
message ...
You might have print area set upto Col F... Clear any print area.

While printing select fit to 1 page wide...

"Joe727" wrote:

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)