Software

Office challenge: How can you get Word to print both Portrait and Landscape in the same document?

Test your Word skills in this week's challenge and learn a few ways to improve performance in Excel.
Not every page in a Word document will fit neatly into the default printing scheme. For instance, you might need to drop a spreadsheet or wide table into a document that's using the Portrait print setting. In this case, you'd probably want Word to print the page containing the table in Landscape, while printing the rest of the document in Portrait. How can you get Word to accommodate both Portrait and Landscape in the same document? Last week we asked you to… List just one change you can make to an Excel spreadsheet to improve its performance.
  • Njconner1 suggested converting formulas to static values to keep a busy spreadsheet from recalculating formulas that don't need recalculating.
  • T8omo1 suggested disabling automatic calculation. That way, you decide when Excel calculates. That certainly speeds up data entry in a busy spreadsheet.
  • Dlcartin recommended a fix for conditional formatting.
  • Wilson.baptista.jr groups dependent formulas.
Feel free to keep this thread going. We'd all benefit from working more efficiently in Excel. [Editor's note: If the performance tips keep rolling in, we'll compile them into a handy reference.]

About

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

18 comments
psabatino
psabatino

At the beginning of the page that needs to be in Landscape mode... I would open the advanced Page Layout tab and set the Orientation to Landscape and change the Apply to drop down to This point forward. If the next page is back to Portrait - Then set it back to Portrait.

EarlMelton
EarlMelton

Why not just take a screen shot of the landscape page, save it as an image file, edit the image in an appropriate program and rotate it 90 degrees, then Insert > Picture > From File?

HRess
HRess

Insert a Next Page section break at the end of the Portrait section and set the next section to Landscape. At the end of the landscape section insert another Next Page section break and set the remainder of the document back to Portrait. heather@deneysreitz.co.za

Cerepha
Cerepha

Use sections in the document. That way you can define not only the orientation for individual sections but also any other page settings you need such a margins headers/footers and so on.

amasa
amasa

I use section breaks to before and at the end of an area I need formatted differently, for example: landscape versus portrait. Word allows you to apply a page setting to this section only.

rjukes
rjukes

With the cursor at the top position of the first page you wish to be landscape, click on the bottom right diagonal arrow on the Format tab (in Word 2007). On the "Margins" tab, go to the bottom window, choose either "From this point forward" or "This Section", then click on the Landscape frame of the Margins tab. Tah, tah, tah, dah!!!

mcrowe
mcrowe

Use the section break before and after you want to change the page orientation.

justinkearney
justinkearney

You can change the orientation of each page in a document. if you click on the 1st page you want to turn, open the page setup dialog and click on the orientation that you want. then change the "apply to" option to this point forward. go to the next page you want to turn back and to it again.

bjmyers17
bjmyers17

Insert a "next page" section break before and after the portion of the document you want to print in landscape. Then change the new section's orientation to landscape; the rest of the document will be unaffected.

tjsan42
tjsan42

At least in my version of word 2007 there is no "format" tab, but if you use the "page layout" and expand the "page setup section" I then get to the margins as you suggest.

carl
carl

I do this one all the time, but would like to take it one step further, how can i get the header and footer to stay in portrait and print the pge landscape, for tables etc. without formating the tables which is time consumming???

ginmemphis
ginmemphis

Here's a tip: If you delete a section break, the previous section takes on the formatting of the second section.

williaa6
williaa6

I've been bugged by this "short coming" for years now, and finally I know how to do it. Thanks very much. :-))

shelbeeray
shelbeeray

I'm not really clear on what you mean, but here are two scenarios I've worked with: To keep initial portrait header/footer on all document pages: - format document in portrait and set headers & footers; -insert section breaks on the pages before & after the page (this includes before and after the table if the table breaks across pages you want in landscape format); - keep the formatting as is for the headers and footers, this should keep the margins & tabs the same as in previous sections, with the same margins. The key is the "same as previous" setting. To create a different layout on the header/footer on the landscape page that you have inserted into a portrait document: -Create document as above in the first step, setting margins and headers & footers in portrait; -Insert section breaks as in first scenario; -in the landscape section, change the header & footer so that they are not "same as previous" and format them the way you prefer, perhaps with different tabs/margins. -in the next section re-set the headers & footers to match the first section and have the following pages set up "same as previous" Does that address your question?

stapleb
stapleb

You could get really tricky. Place all text in a text box on a Portrait page which contains your usual header and footer. Then flip the text in the box until you get the orientation you want. No section breaks needed if you do this. Just another way to deal with it.

.Martin.
.Martin.

good to know there is a solution... only I will forget it next time I need to use it :D

stapleb
stapleb

I don't have a problem at all. Someone wanted to have landscape page printing and portrait headers and footers. I just suggested that instead of a section break and landscaping the page that the data to be landscaped could be placed in a text box and the text flipped on its side in the box to look like landscape.