#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default colomn to row

how can i change the colomn data to a row data
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default colomn to row

Highlight the Range in the column, then do Copy and then select a cell to
paste to and do PasteSpecial Transpose

Vaya con Dios
Chuck, CABGx3



"Robert helou" wrote:

how can i change the colomn data to a row data

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I lable a colomn group in Excel? Gem Excel Worksheet Functions 0 June 8th 06 03:01 PM
HOW DO YOU SET THE DEFAULT FIXED COLOMN WIDTH ON THE EXCEL IMPORT Robert Belote Excel Discussion (Misc queries) 0 May 5th 06 08:33 PM
How do I extract data from every other cell in a colomn? Spencer Christensen Excel Worksheet Functions 1 March 31st 06 08:12 AM
Colomn of strings, how to count each string with "abc" OR "def" Tommy T Excel Worksheet Functions 8 September 5th 05 04:57 PM
sum of colomn.. Zadig Galbaras Excel Discussion (Misc queries) 2 February 7th 05 08:15 PM


All times are GMT +1. The time now is 01:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"