Job & Career

Moving columns and rows cleverly in Excel: Never any other way again

Move columns and rows in Excel
Skip to table of contents
Contents 3 sections
  1. Moving Rows and Columns Without Overwriting
  2. Alternating Colors in Rows in Excel with Just Three Clicks
  3. Conditional Formatting in Excel to Highlight the Most Sales

Would you like to work more efficiently in Excel ? Don't worry, I'll show you how to move columns and rows cleverly! With these tips and tricks, you'll never have problems organizing your data again. Let's get started right away improving your Excel skills.

Preview image: Moving columns and rows cleverly in Excel: Never any other way again

The video is only loaded from YouTube when you play it – data (including your IP address) is then transmitted to YouTube/Google. More in the privacy policy

Moving Rows and Columns Without Overwriting

Move columns and rows in Excel by holding down the Shift key

Sometimes we need to rearrange data in our worksheet. However, moving rows and columns can lead to data loss if it isn't done correctly. To move a row or column in Excel without overwriting content, you can follow these steps:

  • Select the row or column you want to move.
  • Hold down the Shift key while dragging the selection to the desired location.
  • When you release the mouse button, Excel pushes the other cells aside and places your selection in the new position without overwriting anything.

Alternating Colors in Rows in Excel with Just Three Clicks

Embellish columns and rows in Excel with Format as table

Visual distinctions can help you grasp data more quickly. Excel offers a simple way to apply alternating colors in your rows, which significantly improves readability:

  1. Select your data.
  2. In the ribbon, go to "Home" and click on "Format as Table".
  3. Choose a style that uses alternating colors. With just three clicks, you've given your table a clearer structure.

Conditional Formatting in Excel to Highlight the Most Sales

Highlight columns and rows with data bars in Excel

Conditional formatting is a powerful feature in Excel that allows you to visually highlight data based on certain criteria. For example, you can use it to highlight the rows or cells that show the most sales:

  1. Select the cells that contain your sales data.
  2. In the ribbon, go to "Home" and select "Conditional Formatting".
  3. Choose, for example, "Data Bars" and then simply hover the mouse over a predefined design.

With these three simple but effective tips, you can make your work with Excel faster and more efficient. Try them out and see for yourself how they can increase your productivity.

Comments

Register and comment.

Continue reading

You might also like

View all articles →