Excel - Q & A

Excel - Q & A

Q-How to switch Columns and Rows 

In order to switch Columns' positions to Rows' positions or vice versa,  

 provides 8 steps as follows:

   8 Steps To switch Excel columns and rows

        1. Open the spreadsheet you need to change.

        2. If needed, insert a blank worksheet.

        3. Click the first cell of your data range such as A1.

        4. Shift-click the last cell of the range. Your selection should highlight.

        5. From the Home tab menu, select Copy.

        6. At the bottom of the page, click the tab for the blank worksheet such as Sheet2.

        7. In the blank worksheet, click cell A1.

        8. From the Home tab menu, select Paste. The Paste dialog should appear. 

        9. Click the box for Transpose.

Source from the Productivity Portfolio available at https://www.timeatlas.com/switch-excel-columns-rows/

===

Practise

At the Copy step (5)