Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 11th 05, 07:26 PM posted to microsoft.public.excel.worksheet.functions
chickaleeka
 
Posts: n/a
Default How do I change my typing from horizontal to vertical

I am making a chart and I do not know how to make some of my boxes go from
horizontal typing to vertical.

  #2   Report Post  
Old December 12th 05, 12:44 AM posted to microsoft.public.excel.worksheet.functions
woon san
 
Posts: n/a
Default How do I change my typing from horizontal to vertical


Hi,

Select the Cells that are place horozontally..
Select = Copy

Choose a new cell (Cell where you wish the vertical input to start
from)
then choose Paste Special = Transpose.




--
woon san
------------------------------------------------------------------------
woon san's Profile: http://www.excelforum.com/member.php...o&userid=28790
View this thread: http://www.excelforum.com/showthread...hreadid=492565

  #3   Report Post  
Old December 12th 05, 03:18 AM posted to microsoft.public.excel.worksheet.functions
Neil M
 
Posts: n/a
Default How do I change my typing from horizontal to vertical



highlight the cells you want vertical text in first

select formatcells
Click the alignment tab and on the right you can adjust the text from 0 to
90 degrees. You can also select "wrap text" if you have alot of text to type
in one cell. Or you can try shrink to fit.
There are many other options here as far as centering the text or aligning
right or left.

Neil


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I change a cell and cause an automatic change in other cells Swissmiss Excel Worksheet Functions 2 August 12th 05 05:00 PM
Vertical to horizontal swchee Excel Discussion (Misc queries) 5 June 20th 05 04:25 AM
How do I sort a horizontal worksheet to create a vertical table The Hamburger36 Excel Worksheet Functions 1 May 29th 05 06:43 PM
Converting a large vertical mailing list into a horizontal format Kevin VanHalen New Users to Excel 1 April 30th 05 12:23 PM


All times are GMT +1. The time now is 09:28 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017