Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Flipping text
I need to flip my horizontal text to vertical within the cells
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Flipping text
format<cells<alignment<orientation
EricBB "Charlene" wrote: I need to flip my horizontal text to vertical within the cells |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Flipping a Spreadsheet | Excel Worksheet Functions | |||
Flipping Data in Excel | Excel Worksheet Functions | |||
flipping a spreadsheet | Excel Worksheet Functions | |||
Data Flipping | Excel Discussion (Misc queries) | |||
Flipping the order around? | Excel Discussion (Misc queries) |