i need to swith my columns into rows and vice versa can i do this? thanks
J Juan Pablo González Oct 7, 2004 #2 Select the data that you want to "switch", go to an empty area (or a new worksheet), select Edit | Paste Special, and check the "Transpose" box. Click Ok.
Select the data that you want to "switch", go to an empty area (or a new worksheet), select Edit | Paste Special, and check the "Transpose" box. Click Ok.
B Bill Kuunders Oct 7, 2004 #3 edit copy cells select a cell outside the range edit paste special .........tick the transpose option at the bottom Regards Bill K
edit copy cells select a cell outside the range edit paste special .........tick the transpose option at the bottom Regards Bill K
