| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I rotate Horazontial cells vertical, so part of the chart .
Hi I have a spread sheet with the data and cells that run horizontaly across
the top of the spread sheet. I want to cut and paste other cells and rotate the cells so they lay up to one side of the spread sheet cells and the new data will run vertical. I appricate your help. |
|
#2
|
|||
|
|||
|
Look in Help under "Transpose".
-- Vasant "Wendol" wrote in message ... Hi I have a spread sheet with the data and cells that run horizontaly across the top of the spread sheet. I want to cut and paste other cells and rotate the cells so they lay up to one side of the spread sheet cells and the new data will run vertical. I appricate your help. |
|
#3
|
|||
|
|||
|
Select the horizontal cells then "Cut". Then select the cell where you want
the first cell of vertical data to go. Under the edit menu select "Paste Special", then click the "Transpose" box. The horizontal cells should paste verically downward. "Wendol" wrote: Hi I have a spread sheet with the data and cells that run horizontaly across the top of the spread sheet. I want to cut and paste other cells and rotate the cells so they lay up to one side of the spread sheet cells and the new data will run vertical. I appricate your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to list values of last 3 non-blank cells in a vertical bl | Excel Worksheet Functions | |||
| Rotate a box with a cell's contents | Excel Discussion (Misc queries) | |||
| details about vertical alignment in Excel cells | Excel Discussion (Misc queries) | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| How to populate formula in range of vertical cells to next colum | Excel Worksheet Functions | |||
Linear Mode
