Rick's 475th Excel question

OK, just got a a shinny new computer with office 2007 on it.
In Excel how do I move page breaks so that I can get all of some imported data to print on the same page?
In 2003 and earlier, I could just drag the dotted line to where I wanted it Excel would resize the print and away I went.
In 2007 I can switch from Portrait to Landscape, but for the life of me I can’t get the breaks to move so I can get it all on one page.

On the View tab, choose Page Break Preview and pull the dotted lines where needed. You may need to force the number of pages you want under Page Layout --> Page Setup.

In Internet Explorer (doesn’t seem to like playing in Firefox) go to: http://office.microsoft.com/home/video.aspx?assetid=ES102755041033&width=884&height=540&startindex=0&CTT=11&Origin=HA102549101033&app=EXCEL&ver=12
That is a video demo on page breaks and all that jazz.

Shorter answer is look under Page Layout tab across the top of choices and play with it.

Also, if the Print Area is the same as what you want on one page, under Page Setup choose Fit To 1 page wide by 1 high to fit it all on one page.

Don’t you love the way MS made it easier by making you learn something all over again. Thanks Bill. I’ve got a pie with your name on it if you’re hungry (or not).

Yes, and how obvious those new menus are. Who would expect that to insert rows or columns you’d go to the “Insert” section? It’s much more intuitive to put that on the “Home” section :rolleyes:

:smack:
There it is! Damn I feel so stupid. Thanks.

Why should hou feel stupid. It’s like putting the trunk release button under the hood of the car. It’s retarded.

Thanks, guys, for helping convince me to NEVER replace my beloved old Excel 2003 with that 2008 upstart!

Actually, there are some advantages to the new Excel. For me, the biggest is that the limits on numbers of rows and columns have greatly increased. From time to time, I need to bring large text files into Excel, and it’s good not to have the 65K limit on the number of rows any more.

I like the Filter and Sort options. You can sort by cell color. You can also filter by date, but it will give you a tree starting with year, then month, then day so you don’t have to filter by individual dates if you don’t need to.

In other news…

I was working on an Excel sheet last night for my fantasy draft. I had one key filter I was using (Drafted?) that would hide players as they were picked. But I had to refresh the filter every time. Is there a setting (in 2007) that keeps the filter “active”?

The only way I can see is to rehighlight the whole sheet, click on the filter and say OK.

ETA: The filter has all choices checked except “Drafted”, right?

Correct (well, actually it only has “blank” selected, but same thing). I just have to reclick the filter and hit “OK” each time I needed to look at it with fresh eyes.

Just because they optimized button placement on the ribbon from researching the most and least-used features? Sheesh, some people are really against change! :wink:

I love the ribbon and the live previews the formatting options give in Office '07. I could never go back to '03 now (especially since I get '07 for free :p).

Those startled me at first! I am a little ham-handed with font size and the image with expand and contract all over the place–I had to learn to control that. I could do without it.