Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose Error
Hi,
I have 414 data using same number of rows in column A. I tried to use tranpose function by copying the data, right-click a cell, select past special, and click transpose. However, I get an error message. It says The information cannot be pasted because The Copy area and the paste area are not the same size and shape. Try one of the following: - Click a single cell, and then paste - which is dumb because it is not tranposing the data. - Select a rectangle that's the same size and shape, and then paste. I know I did transpose data before but can't figure out why it's not working this time. Can any give me a solution to this??? I appreciate your reply in advance. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose Error
Did you try to highlight from a1 to a414, and then select b1, do transpose
there, the delete column a. escapeman wrote: Hi, I have 414 data using same number of rows in column A. I tried to use tranpose function by copying the data, right-click a cell, select past special, and click transpose. However, I get an error message. It says The information cannot be pasted because The Copy area and the paste area are not the same size and shape. Try one of the following: - Click a single cell, and then paste - which is dumb because it is not tranposing the data. - Select a rectangle that's the same size and shape, and then paste. I know I did transpose data before but can't figure out why it's not working this time. Can any give me a solution to this??? I appreciate your reply in advance. Thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200712/1 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose Error
Note that if you are using XL2003 or earlier, there are only 256
columns that you can use, so you will not be able to transpose 414 rows. Pete On Dec 8, 5:24 am, escapeman wrote: Hi, I have 414 data using same number of rows in column A. I tried to use tranpose function by copying the data, right-click a cell, select past special, and click transpose. However, I get an error message. It says The information cannot be pasted because The Copy area and the paste area are not the same size and shape. Try one of the following: - Click a single cell, and then paste - which is dumb because it is not tranposing the data. - Select a rectangle that's the same size and shape, and then paste. I know I did transpose data before but can't figure out why it's not working this time. Can any give me a solution to this??? I appreciate your reply in advance. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transpose from Col to row | Excel Discussion (Misc queries) | |||
Transpose Row by Row | Excel Worksheet Functions | |||
I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES | Excel Worksheet Functions | |||
Transpose | Excel Worksheet Functions | |||
TRANSPOSE() | Excel Worksheet Functions |