Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default how entries in a column can be put into a row

dear all
i have some long data in a column and i want it to put into a row. how can i
do this without cutting individual entries and pasting in row
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default how entries in a column can be put into a row

Hi Afzaal,

Select the cells,
Edit | Copy
Select a cell outside the copy area
Edit | PasteSpecial | select the 'Transpose' option


---
Regards,
Norman



"AFZAAL" wrote in message
...
dear all
i have some long data in a column and i want it to put into a row. how can
i
do this without cutting individual entries and pasting in row



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
Counting entries in column based on condition in another column RobertR Excel Worksheet Functions 1 February 8th 07 03:54 PM
Count entries in one column based on values in another column Kurt Excel Worksheet Functions 7 January 10th 07 09:29 PM
Locking column entries to an adjacent linked column Steeljaw Excel Discussion (Misc queries) 1 January 23rd 06 10:45 PM
how entries in a column can be put into a row AFZAAL Excel Programming 1 June 27th 05 01:08 PM
how entries in a column can be put into a row AFZAAL Excel Programming 2 June 27th 05 10:34 AM


All times are GMT +1. The time now is 05:39 PM.

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

About Us

"It's about Microsoft Excel"