change the orientation of a worksheet to Landscape

G

Gord Dibben

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
 

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

Determine if previous "character" is a section break 3
Print order of TriFold - Publisher 365 0
Change the orientation of a word document with access to print in booklet mode 0
Excel Page orientation 0
Word - Change landscape to Portrait ?? 5
Page orientation change port to lands KEEPING PAGE NUMBERING 0
Printing and scaling: why does Excel behave in such a way? PLZ HELP!!! 5
Shape Fill Help 3

Top