change the orientation of a worksheet to Landscape

  • Thread starter Thread starter Guest
  • Start date Start date
For printing or for on sheet orientation?

Printing.....File>Page Setup>Page. Check "landscape"

Change orientation......Copy data range. Select a cell out of the copied
range and Paste Special>Transpose.

Note: with the Transpose, you are limited to 256 columns so if you have more
rows than that you are outtaluck.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Page orientation 1
Printing landscape? 1
Printing and scaling: why does Excel behave in such a way? PLZ HELP!!! 5
Excel charts will not go back to Landscape when selected 2
Excel 2007 Landscape Orientation 6
A2007 PDF email changing orientation 1
Page layout/ orientation problem 1
Orientation Landscape but want Page #s to Print Portrait 1

Back
Top