Sometimes in order to view and compare data more intuitively, we need to move the position of the column. You can use multiple methods for one or more columns.
Microsoft Excel is one of the best software that can be used to arrange values or words in a table. Sometimes, you may want to compare and contrast certain data in different columns. The value of the worksheet may be too great, and you may be confused when evaluating the form as it is.
Here are some ways you can move columns in “Ladies”. Excel is effortless.
1. Copy and paste method
In this case, you need to copy and paste one or more columns.
step 1: To move a column, click the English letter at the top to select the entire column.
Step 2: Second, use the keyboard shortcut (Ctrl + C) to copy.
Step 3: You now need to copy the content to the new column. Therefore, click on your target letter position, such as “C”. Use the keyboard shortcut (CTRL + V) to paste the “copied column” into a blank column.
the fourth step: You can now delete the original column. Click on a letter like “A”, right-click, and select Delete from the drop-down list.
2. Drag the column
You can also use the drag method to move columns in Excel.
step 1: Click the letter above the target column. If you want to move column A, move the mouse to column A.
Step 2: Before clicking, the mouse pointer will turn into a black downward arrow. Therefore, click once to select the entire column.
Step 3: Then, move the mouse to the boundary of the column. When a black four-way arrow appears, hold down the shift key.
the fourth step: At this time, you can drag the left mouse button to move the column left and right. This will move the column to another space. For example, from A to E.
hint: If you want to move multiple columns, you can hold down the Ctrl key to make multiple selections.
3. Sort all columns
This is the adjustment method for large watches. This method is very effective if you have to reposition many columns in the table. This method is faster!
step 1: First, create a new blank row at the top. You can do this on line 1. Move the cursor to 1; a black arrow will appear.
Step 2: Click on row 1 to highlight the entire row.
Step 3: When the first row is highlighted, right-click the pop-up menu and select “Insert”. A new row will be created at the top.
the fourth step: You can now adjust the order of the columns as needed. Then enter the numbers according to your preferences.
Step 5: Next, you need to select all the columns to sort them. , Left-click on the farthest column at the top, and then move the mouse to the lowest column at the bottom.
Step 6: After selecting all the columns, on the top menu bar, click “Data”> “Sort”. A dialog window will appear. Modify it according to your needs.
Step 7: You can change the order to arrange values from smallest to largest, largest to smallest, value, cell color, font color, cell icon, or individual columns. When you are done, remember to click “OK” to apply the changes.
Now your values will be sorted according to the specific sorting method. You can also do this for words and sort them according to the alphabet.
Use Microsoft Excel to move columns easily.
You can also use the same method to move rows. The ultimate goal of adjusting the table is to make it more concise and understandable. This will make it easier for others to get valuable things from your data.
These new tips and tricks will help you save enough time when working with Excel worksheets. Make your presentation easy to understand!