How to Select Two Separate Columns in Excel on Mac

Charlotte Daniels

Mac, Tutorials

Are you struggling to select two separate columns in Excel on your Mac? Don’t worry, we’ve got you covered!

In this tutorial, we will guide you through the process of selecting two columns simultaneously in Excel on Mac. Let’s get started!

Method 1: Using the Command Key

If you want to select two separate columns that are not adjacent to each other, you can use the Command key. Here’s how:

  1. Step 1: Open Excel on your Mac and open the worksheet where your columns are located.
  2. Step 2: Click on the first column header that you want to select.
  3. Step 3: Hold down the Command key (⌘) on your keyboard.
  4. Step 4: While holding down the Command key, click on the second column header that you want to select.

Congratulations! You have successfully selected two separate columns using the Command key. Now let’s move on to method two.

Method 2: Using the Shift Key

If you want to select two adjacent columns, you can use the Shift key.

  • Step 3: Hold down the Shift key (⇧) on your keyboard.
  • Step 4: While holding down the Shift key, click on the second column header that you want to select.
  • Great job! You have now selected two adjacent columns using the Shift key. Let’s move on to some additional tips and tricks.

    Tips and Tricks

    Here are a few additional tips and tricks that can enhance your column selection experience:

    • Selecting Multiple Non-Adjacent Columns: To select multiple non-adjacent columns, you can use either the Command key or the Shift key. Simply follow the steps mentioned in methods 1 and 2, but instead of selecting just one column, select multiple columns by clicking on their respective headers while holding down the Command or Shift key.
    • Selecting Entire Columns: To select an entire column, simply click on its header. If you want to select multiple entire columns, hold down either the Command or Shift key while clicking on their headers.

    With these tips and tricks, selecting two separate columns in Excel on your Mac should be a breeze. Practice these methods and explore further to become an Excel pro!

    Conclusion

    In this tutorial, we learned how to select two separate columns in Excel on Mac using different methods. Whether you need to select non-adjacent columns or adjacent columns, these techniques will help you accomplish your tasks efficiently.

    Remember to use the Command key for non-adjacent columns and the Shift key for adjacent ones. We also shared some additional tips and tricks for a better selection experience.

    We hope this article was helpful to you. Happy Excel-ing!

    Android - iPhone - Mac

     © 2023 UI-Transitions

    Privacy Policy