How do I rotate Horazontial cells vertical, so part of the chart .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word How to rotate individual letters in word 2016 0
Using "Verifiers" 2
Conditional formatting 2
formula 2 display selected objects ONLY in new sheet from another 1
Macro that Finds the First Value in a range using a Combobox (drop down menu) 2
How do I make a cell refrence another cell based on conditions? 1
How to change cell background color as part of the If statement? 2
Removing a picture box from an Excel 2007 spreadsheet 5

Back
Top