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
 
Top