Once your data set has been converted to a table, you can use the following shortcuts. In the dialog box that appears, ensure My table has headers is checked and click OK. Click in the data set and then press Ctrl + T.Click in the data set and then click the Insert tab in the Ribbon.Click Format as Table in the Styles group and click a style in the gallery. Click in the data set and then click the Home tab in the Ribbon.You can convert a data set to a table in 3 ways: It's also a good idea to remove blank columns and blank rows. Be entered in columns and rows with column headings in the first row and similar data entered in the rows below.Recommended article: 10 Great Pivot Table Shortcutsĭo you want to learn more about Excel? Check out our virtual classroom or live classroom Excel courses >ĭata that is going to be converted into an Excel table should: Tables are one of Excel's most important tools and a table is, essentially, a dynamic named range. It is not simply data entered in columns and rows. Keep in mind that a table in Excel is created by converting a data set to a table. You can use shortcuts to select an entire table, an entire row, an entire column or ranges in tables. There are many different shortcuts for selecting elements in Microsoft Excel tables. That’s It! You can now easily Swap two or more columns in Excel by following our step-by-step tutorial.How to Quickly Select Columns, Rows and Ranges in Excel Tablesīy Avantix Learning Team | Updated March 24, 2021Īpplies to: Microsoft ® Excel ® 2013, 2016, 2019 and 365 (Windows) The methods discussed in this post work for rows as well. How can I exchange data that has been arranged in rows?
Through this, you can easily swap the position of both columns.įor swapping single-cell columns, use the drag and drop method.Move the second column to the place of the first one.To highlight the second column, use Ctrl + Space.This will insert the new column in place of the original one.
Hold Ctrl + Space for highlighting the full column.Now, let’s see how you can swap two excel columns with the keyboard shortcut method.įollowing are the steps for swapping columns by the keyboard shortcuts method: Unfortunately, it also does not function for non-contingent columns. This is a more time-consuming method than dragging columns, but it may be suitable for people who prefer shortcuts to fumble with the mouse. When you click, it should highlight the entire column. Click on the header (top) of the column to which you want to move its destination.
Instead, while holding down the Shift key, click on the correct position on the cell. In Excel, whenever you’ll try to drag the column from one place to another, it will only highlight the cells instead of moving them from their position. This article is a step-by-step guide to the top 4 methods for quickly changing the location of your Excel columns with minimal effort. If you use Excel tables frequently in your everyday work, you know that you must reorganize the columns from time to time no matter how logical and well-thought-out a table’s structure is. Sometimes you’ll need to reorganize data, and other times you’ll want to compare particular columns side by side. If you use Excel tables regularly for business, you have organized your data in columns. In this article, we’ll learn to swap columns in Excel.