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.