Troubleshooting on How to Move Columns in Excel But these tend to be highly specific and are usually best used by those with an in-depth knowledge of Excel. Macros may be potentially useful in some circumstances. Plug-ins can create more headaches by adding unnecessary toolbars and duplicate functions to an already robust program. This is doable, but requires more advanced knowledge, so you should proceed with columns. There are a few other ways to move columns in Excel, but they typically require the use of a plug-in or creating a Macro. Are There Other Ways How to Move Columns in Excel? With both techniques above, when you move a column, you also move all of the data within each cell of the column.įormats, formulas, and values all maintain their original integrity regardless of which procedure you use.Īdditionally, although we focused on columns, these instructions will also work when you need to move rows within your Excel spreadsheet. ![]() What Happens When You Move Columns in Excel If you perform the same steps above without the shift key, the column you are moving will replace the info in the destination column.Įxcel will prompt you with a warning message before you complete the drop. The shift key is vital in drag and drop as it directs Excel to insert the columns. Once you reach the end location, just let go of the mouse button first and then the shift key.A thin line will appear to help guide you before placing the column. Hold down the Shift button and then pull the column towards its intended destination.Note that depending on your version of Excel and if you are using a Mac, the four arrows may alternatively be a small hand symbol. ![]() Along either edge of the highlighted column, hover your mouse until the cursor changes to four small arrows and click and hold the mouse button.You can also perform this task using just a section of data. First, highlight the column you are moving.This is relatively easy to complete although it may take a couple of attempts before you can do it efficiently. How to Move Columns in Excel: Drag and DropĪnother efficient method to use when you need to move columns in Excel is to drag and drop. Be mindful that this will alter your sheet in a specific area as opposed to the top to bottom change that occurs in the above examples. You can also select columns within your spreadsheet and move those as necessary without needing to select the column headers.The cut function is unable to perform this task. If trying to move multiple columns, i.e., Column A and Column D, this will only work with the copy function.Cut, copy, insert and paste can all be used with a single column or a range of columns depending on your needs.Select column B, right-click and choose Paste from the pop-up.Going back to our previous example, here’s how to move columns in Excel when replacing data in one column with data from another. How to Move Columns in Excel: Replace Data in One Column with Data from Another But doing so will replace the old data with the new. You can also use the paste function to place your column in its new location. Note that the insert function will shift your data to the right to make room for the new column. If you cut column D and want it inserted after column A, then you would select column B, right-click and choose Insert Cut Cells from the pop-up. When you are ready to place your column, select the heading of the column to the right of where you want it to go.Copying a selection of information creates a duplicate of that data for you to place elsewhere.When you cut a selection, you are removing it from its original location and placing in another part of your spreadsheet or workbook. Be mindful of the difference between Cut and Copy.For the move functions, you can use shortcut Control X for cut and Control C for copy. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |