Excel: Moving, formatting columns and rows, and applying conditional formatting

In this tutorial, you will learn how to rearrange columns and rows in Excel without overwriting data, how to format tables, and how to apply conditional formatting to improve the readability of your data. The following step-by-step tutorial is based on the provided transcript.

Move Columns

1. Select Column:
   • Select the entire column you want to move by clicking on the column letter.
2. Use Shift Key:
   • Hold down the Shift key.
   • Click on the column and drag it to the desired position. You will notice that the column's outline becomes thicker, indicating that the column will be moved between the other columns without overwriting data.
3. Release Column:
   • Release the mouse to insert the column at the new position.

Move Rows

1. Select Row:
   • Select the entire row you want to move by clicking on the row number.
2. Use Shift Key:
   • Hold down the Shift key.
   • Click on the row and drag it to the desired position. Again, the outline becomes thicker to symbolize inserting it between other rows.
3. Release Row:
   • Release the mouse to insert the row at the new position.

Format Table

1. Copy and Paste Data:
   • Copy your data (e.g., with Ctrl+C) and paste it into a new table (e.g., with Ctrl+V). You can paste the data unformatted by adjusting the options when pasting.
2. Format Table:
   • Select the data you want to format.
   • Go to the "Home" tab and click on "Format as Table".
   • Choose a table format from the displayed list (e.g., green).
   • Confirm whether the table has headers by checking the corresponding box.

Apply Conditional Formatting

1. Select Data:
   • Select the data range you want to conditionally format.
2. Apply Conditional Formatting:
   • Go to the "Home" tab and click on "Conditional Formatting".
   • Choose one of the following options:
     • Data Bars: Displays values as bars in the cells.
     • Color Scales: Applies a color scale based on the values.
     • Icon Sets: Adds icons to categorize data visually.
3. Adjust Formatting:
   • Hover over the different options to preview the formatting.
   • Select the desired formatting (e.g., a color scale).

Practical Application of Conditional Formatting

• Conditional formatting allows you to quickly identify the highest and lowest values in your data.
• In this example, sales figures have been highlighted with colors, making the highest sales figures immediately visible.

By following these steps, you can efficiently move columns and rows in Excel, format your data attractively, and make important information visible at a glance using conditional formatting. These techniques contribute to improving data organization and visualization, making it easier to work with large datasets.