#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 18
Default Flipping text

I need to flip my horizontal text to vertical within the cells
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 50
Default Flipping text

format<cells<alignment<orientation
EricBB


"Charlene" wrote:

I need to flip my horizontal text to vertical within the cells

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 168
Default Flipping text

Let's say you have data in A1:D1.

1. Highlight A1:D1
2. Ctrl-C to copy
3. Select destination cell (ex: A2)
4. Ctrl-V to paste

Or you could use an array formula. Say you have data in A1:D1 (4
cells)

Select four vertical cells (ex: A4:A7) and type =TRANSPOSE(A1:D1), hit
ctrl-shift-enter because this is an array formula. Then paste in the
values and delete the original cells.


HTH,
JP


On Nov 15, 10:05 am, Charlene
wrote:
I need to flip my horizontal text to vertical within the cells


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 43
Default Flipping text

Hi,

Select the cell which you want to change the direction, then click as follows:

Format -- Cells -- (Orientation) -- Then click the degree spin button,
upto the direction u want to place the text.

Hope this will clear your doubt.

Regards,
Soundar.

"Charlene" wrote:

I need to flip my horizontal text to vertical within the cells

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 66
Default Flipping text

Charlene wrote:
I need to flip my horizontal text to vertical within the cells


Charlene,

I suppose that would depend on whether you want the letters rotated or
normal. Format/cell/alignment will turn the letters with the direction
of text. There's also an option there on the left of the "compass" that
will stack your letters.

Beege
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
Flipping a Spreadsheet Joy Excel Worksheet Functions 1 July 18th 07 02:16 PM
Flipping Data in Excel August Excel Worksheet Functions 3 January 11th 07 10:55 PM
flipping a spreadsheet remarque Excel Worksheet Functions 2 October 27th 06 01:55 PM
Data Flipping alamsemu Excel Discussion (Misc queries) 1 March 10th 05 06:56 AM
Flipping the order around? thrava Excel Discussion (Misc queries) 4 January 14th 05 02:23 PM


All times are GMT +1. The time now is 11:23 PM.

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

About Us

"It's about Microsoft Excel"