Changing columns of data to rows

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I'm sure theres a way of 'rotating' a column of data to become a row. Any
ideas please?

Mike
 
Hi Mike

Copy the cells in the Column

Select a cell where you want to copy to
Choose paste special...Transpose

Remember Excel have 256 columns
 
Now how do I count the number of words in a column?!

If all the cells have a value you can do this

In the Statesbar you see the word Num on the right
right click on it and choose Count.
If you select the cells in the column you see the count in
the Statusbar.

This will only work if all the cells have a value

If you want to use VBA there is a other solution
Let me know if you want that
 
OK. Now one final one...!

I was sent some Excel spreadsheets and the normal axes (A:1) etc shows as
(1:1) with numbers only instead of a number and a letter. Everything seems
to work, but is this something I cab switch off?

Thanks again

Mike
 
Tools|Options|General Tab
Uncheck the R1C1 reference style checkbox.

And save your workbook.

Excel picks this setting up from the first workbook you open in that session.
(If you have others saved as R1C1 style and open them first, you'll have to do
it again. So it's a good one to remember.)
 
Thanks all!

Mike


Dave Peterson said:
Tools|Options|General Tab
Uncheck the R1C1 reference style checkbox.

And save your workbook.

Excel picks this setting up from the first workbook you open in that session.
(If you have others saved as R1C1 style and open them first, you'll have to do
it again. So it's a good one to remember.)
Click to expand...
 
Back
Top