Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Name: Jest8 Date: July 7, 1999 at 14:02:03 Pacific
Reply:
Try highlighting the row you need to copy,right click|copy, then go to the top of the column where you want the info to go (you might have to create a new column)Then right click|Paste Special|transpose.
That (should) do it G'luck
0
Response Number 2
Name: john Date: June 30, 2000 at 01:17:55 Pacific
Reply:
Hi I tried to convert comlumn to row..! But how can I set it as a macro to tranpose within the whole sheet..For Example..one complete order is from row1 to row4 but row2..row4 are the attributes..I know how to transpose one order..but how can i set a marco to do this for n orders..?please help
Summary: There is no true way to do this. You can lock the cells but like you say it can be apsted and unlocked. Another is third party software but it is just like Excel and can be gotten around. One last sug...
Summary: We are in the process of converting from Lotus to Excel. There are a couple of spreadsheets that use the Lotus "pipe - asterisk" |* in column A to supress the printing of the line. Is there any eq...
0 
