# Rick's 475th Excel question **URL:** \ **Category:** Factual Questions\ **Created:** [September 1, 2009, 7:18pm UTC](https://boards.straightdope.com/t/ricks-475th-excel-question/508523 "2009-09-01T19:18:05Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![Rick](https://avatars.discourse-cdn.com/v4/letter/r/9f8e36/32.png) [@Rick](https://boards.straightdope.com/u/Rick)\ **Post date:** [September 1, 2009, 7:18pm UTC](https://boards.straightdope.com/t/ricks-475th-excel-question/508523/1 "2009-09-01T19:18:05Z")
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. ---
**Author:** ![gigi](https://avatars.discourse-cdn.com/v4/letter/g/a587f6/32.png) [@gigi](https://boards.straightdope.com/u/gigi)\ **Post date:** [September 1, 2009, 7:32pm UTC](https://boards.straightdope.com/t/ricks-475th-excel-question/508523/2 "2009-09-01T19:32:37Z")
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. ---
**Author:** ![Whack-a-Mole](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/whack-a-mole/32/141_2.png) [@Whack-a-Mole](https://boards.straightdope.com/u/Whack-a-Mole)\ **Post date:** [September 1, 2009, 7:33pm UTC](https://boards.straightdope.com/t/ricks-475th-excel-question/508523/3 "2009-09-01T19:33:09Z")
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](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. ---
**Author:** ![gigi](https://avatars.discourse-cdn.com/v4/letter/g/a587f6/32.png) [@gigi](https://boards.straightdope.com/u/gigi)\ **Post date:** [September 1, 2009, 7:36pm UTC](https://boards.straightdope.com/t/ricks-475th-excel-question/508523/4 "2009-09-01T19:36:42Z")
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. ---
**Author:** ![Magiver](https://avatars.discourse-cdn.com/v4/letter/m/4491bb/32.png) [@Magiver](https://boards.straightdope.com/u/Magiver)\ **Post date:** [September 1, 2009, 10:28pm UTC](https://boards.straightdope.com/t/ricks-475th-excel-question/508523/5 "2009-09-01T22:28:17Z")
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). ---
**Author:** ![Giles](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/giles/32/60_2.png) [@Giles](https://boards.straightdope.com/u/Giles)\ **Post date:** [September 1, 2009, 11:10pm UTC](https://boards.straightdope.com/t/ricks-475th-excel-question/508523/6 "2009-09-01T23:10:13Z")
> [@Magiver](#): > > 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: ---
**Author:** ![Rick](https://avatars.discourse-cdn.com/v4/letter/r/9f8e36/32.png) [@Rick](https://boards.straightdope.com/u/Rick)\ **Post date:** [September 2, 2009, 12:28am UTC](https://boards.straightdope.com/t/ricks-475th-excel-question/508523/7 "2009-09-02T00:28:35Z")
> [@gigi](#): > > 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. :smack: There it is! Damn I feel so stupid. Thanks. ---
**Author:** ![Magiver](https://avatars.discourse-cdn.com/v4/letter/m/4491bb/32.png) [@Magiver](https://boards.straightdope.com/u/Magiver)\ **Post date:** [September 2, 2009, 12:49am UTC](https://boards.straightdope.com/t/ricks-475th-excel-question/508523/8 "2009-09-02T00:49:03Z")
> [@Rick](#): > > :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. ---
**Author:** ![Daylate](https://avatars.discourse-cdn.com/v4/letter/d/9dc877/32.png) [@Daylate](https://boards.straightdope.com/u/Daylate)\ **Post date:** [September 2, 2009, 12:59am UTC](https://boards.straightdope.com/t/ricks-475th-excel-question/508523/9 "2009-09-02T00:59:54Z")
Thanks, guys, for helping convince me to _ **NEVER** _ replace my beloved old Excel 2003 with that 2008 upstart! ---
**Author:** ![Giles](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/giles/32/60_2.png) [@Giles](https://boards.straightdope.com/u/Giles)\ **Post date:** [September 2, 2009, 1:08pm UTC](https://boards.straightdope.com/t/ricks-475th-excel-question/508523/10 "2009-09-02T13:08:04Z")
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. ---
**Author:** ![gigi](https://avatars.discourse-cdn.com/v4/letter/g/a587f6/32.png) [@gigi](https://boards.straightdope.com/u/gigi)\ **Post date:** [September 2, 2009, 2:29pm UTC](https://boards.straightdope.com/t/ricks-475th-excel-question/508523/11 "2009-09-02T14:29:19Z")
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. ---
**Author:** ![Munch](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/munch/32/5281_2.png) [@Munch](https://boards.straightdope.com/u/Munch)\ **Post date:** [September 2, 2009, 2:36pm UTC](https://boards.straightdope.com/t/ricks-475th-excel-question/508523/12 "2009-09-02T14:36:17Z")
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”? ---
**Author:** ![gigi](https://avatars.discourse-cdn.com/v4/letter/g/a587f6/32.png) [@gigi](https://boards.straightdope.com/u/gigi)\ **Post date:** [September 2, 2009, 5:38pm UTC](https://boards.straightdope.com/t/ricks-475th-excel-question/508523/13 "2009-09-02T17:38:34Z")
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? ---
**Author:** ![Munch](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/munch/32/5281_2.png) [@Munch](https://boards.straightdope.com/u/Munch)\ **Post date:** [September 2, 2009, 7:55pm UTC](https://boards.straightdope.com/t/ricks-475th-excel-question/508523/14 "2009-09-02T19:55:14Z")
> [@gigi](#): > > 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. ---
**Author:** ![BrandonR](https://avatars.discourse-cdn.com/v4/letter/b/779978/32.png) [@BrandonR](https://boards.straightdope.com/u/BrandonR)\ **Post date:** [September 2, 2009, 8:02pm UTC](https://boards.straightdope.com/t/ricks-475th-excel-question/508523/15 "2009-09-02T20:02:02Z")
> [@Daylate](#): > > Thanks, guys, for helping convince me to _ **NEVER** _ replace my beloved old Excel 2003 with that 2008 upstart! Just because they optimized button placement on the ribbon from researching the most and least-used features? Sheesh, some people are really against change! 😉 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). ---
**Author:** ![gigi](https://avatars.discourse-cdn.com/v4/letter/g/a587f6/32.png) [@gigi](https://boards.straightdope.com/u/gigi)\ **Post date:** [September 2, 2009, 8:06pm UTC](https://boards.straightdope.com/t/ricks-475th-excel-question/508523/16 "2009-09-02T20:06:52Z")
> [@BrandonR](#): > > the live previews the formatting options give in Office '07 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.