ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Print (https://www.excelbanter.com/excel-discussion-misc-queries/223273-print.html)

Jane Griffel[_2_]

Print
 
How do I change a group/range of cells to print vertical rather then horizontal
without having to change all the cells manually

Sheeloo[_3_]

Print
 
Requirement not clear. More information needed.
Example?

Page Setup has an option for Page Order which has two choices;
Down, then over
Over, then down

Is that what you are looking for?

"Jane Griffel" wrote:

How do I change a group/range of cells to print vertical rather then horizontal
without having to change all the cells manually


Dave Peterson

Print
 
Maybe...

Insert a new worksheet (for printing only)
Select the range (single row???) to print
and then select A1 of that new sheet
Edit|Paste special|transpose


Jane Griffel wrote:

How do I change a group/range of cells to print vertical rather then horizontal
without having to change all the cells manually


--

Dave Peterson

Gord Dibben

Print
 
Select all the cells in the range and FormatCellsAlignment

Change Orientation to Vertical?


Gord Dibben MS Excel MVP

On Thu, 5 Mar 2009 16:27:01 -0800, Jane Griffel
wrote:

How do I change a group/range of cells to print vertical rather then horizontal
without having to change all the cells manually




All times are GMT +1. The time now is 08:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com