To select an entire row in Excel, press Shift+Space. This method is especially helpful when you’re working on long Excel lists with hundreds of rows and columns because it allows you to swap every cell in your row at the same time. You can use the same technique to swap data between columns. You have just moved the contents from one row to another with a few clicks. Right-click on the now-empty row 7 and select “Delete.”.Copy cell A7 and paste it into the empty cell above (in our example, this is the label “Computer 5”).The I-bar changes to horizontal or vertical as you move the range, and separates the columns or rows where it will move the range to. This also works with rows, and with ranges of columns or rows. Select the empty cell next to Computer 7 (that is, cell B9) and press “Ctrl+V.” Then you can drag the column to the left or right (using the mouse) and it will move the column there without overwriting data or leaving a blank column.The data for Computer 5 moved a row below as well, which means you want to select cells B7, C7, and D7 to get the data for Computer 5.Click cell B6 in the newly created row 6 and press “Ctrl+V.” The data from Computer 7 will move to row 6.You can select the cells with your mouse or with the Shift button, and then press “Ctrl+X” to cut. Find this row and cut out the info from columns B, C, and D. Select the column by clicking your mouse on the letter deno. Adding a new row moved “Computer 7” from row 8 to row 9. Learn how switch columns around in Microsoft Excel using drag and drop.Steps to switch columns:1.Do it by right-clicking on row 6 and selecting the “Insert” option. Insert a new row between Computers 4 and 5.Here is precisely what you have to do if you want to swap the data associated with Computer 5 and with Computer 7: But first, you will need to create an empty row and place the data there. Alternatively, right-click and drag your mouse to highlight the cells. Hold the SHIFT key and click the last cell on the range. First, open the spreadsheet that you want to split a column in excel. This is an efficient method, as it is easy to implement and saves time as well. Method 2 Transposing Rows to Columns Using TRANSPOSE Formula.
#HOW TO SWAP COLUMNS IN EXCEL HOW TO#
This method simply requires you to copy the information from one row and paste it into the other. If you have a Name column, you can separate it into First and Last name columns. How to Convert Rows to Columns in Excel There are 2 different methods for converting rows to columns in Excel, which are as follows: Method 1 Transposing Rows to Columns Using Paste Special. You can use it to swap entire rows or columns at once, rather than switching the data cell by cell. It is straightforward and takes only a few seconds to complete. The first method is used for many different operations in Excel.