How to Select an Entire Column in Excel (5 Quick Methods)

Get FREE Advanced Excel Exercises with Solutions!

While working in Microsoft Excel sometimes we need to select an entire column so that we can edit and organize data according to our choice. It might seem difficult to you to select an entire column quickly. Today in this article, I am sharing with you how to select an entire column in Excel. Stay tuned!


5 Easy Methods to Select an Entire Column in Excel

In the following, I have explained 5 easy and simple methods to select an entire column in Excel.

Suppose we have a dataset of some Student Name, Department, and their Obtained Mark in a table. Now, we will select an entire column using some shortcuts and features of Excel.


1. Clicking Column Letter to Select an Entire Column

The simplest way to select an entire column in Excel is to click the column letter placed at the top of the worksheet. Follow the instructions below-

Steps:

  • First, opening the worksheet, choose any column letter from the top to select the whole column. Here I have chosen D to select the entire column D.

Clicking of Column Letter to Select an Entire Column

  • As you can see, we have successfully chosen the entire column in our worksheet.

Clicking of Column Letter to Select an Entire Column


2. Using Keyboard Shortcut to Choose an Entire Column

We always look for shortcuts to increase our productivity at the workstation. In this method, I have explained a keyboard shortcut to select an entire column.

Steps:

  • Presently, open the worksheet and choose any cell from a column which you want to select.
  • Gently, press the CTRL + SPACEBAR key from the keyboard.

Using Keyboard Shortcut to Choose an Entire Column

  • Finally, the entire column is selected at a glance. Simple isn’t it?


3. Utilize Name Box Feature to Select Column from a Worksheet

If you want you can also utilize the name box feature to choose an entire column from any worksheet. For that,

Steps:

  • To start with, choose the name box and type “C:C”. Here, I wrote “C:C” in the name box as I want to choose the entire column-C.

  • Within a moment, the entire column-C is selected from the worksheet.

Utilize Name Box Feature to Select Column from a Worksheet


4. Using Shortcuts to Select Multiple Columns

You must be wondering if it’s easy to select an entire column but is it possible to choose multiple columns from a worksheet? Well, the answer is yes. You can choose both contiguous and non-contiguous columns with the help of some shortcuts.


4.1. Contiguous Columns

In this sub-method I have described about selecting contiguous columns. Follow the steps below-

Steps:

  • First, choose a column (C) and drag the mouse toward another column when the Handle icon appears.

Using Shortcuts to Select Multiple Columns

  • Simply, other multiple columns in the worksheet will be selected.


4.2. Non-Contiguous Columns

In some cases, you might need to choose multiple non-contiguous columns. You can press Ctrl + select any cell and choose an entire column by Ctrl + Space or follow the steps below

Steps:

  • Similarly, choose any column (C) and hold the CTRL key from the keyboard.

Using Shortcuts to Select Multiple Columns

  • While holding the CTRL key choose any column of your choice and it will be selected for further editing.

Using Shortcuts to Select Multiple Columns


5. Utilize Named Range to Choose an Entire Column

Sometimes you might need to change data or edit columns multiple times from a workbook. In that situation, you can define a name from the Formulas feature to work with great productivity. Below I have explained the procedures. Please follow-

Steps:

  • First, choose any column (E) and click the Define Name option from the Formulas feature.

Utilize Named Range to Choose an Entire Column

  • A new window will pop-up named New Name.
  • From the new window select a name in the Name section and press OK to continue.

Utilize Named Range to Choose an Entire Column

  • Next, coming back to the worksheet, choose Column E from the drop-down list of Name Box.

  • Thus, we have successfully selected the entire column from the worksheet.

Utilize Named Range to Choose an Entire Column

Read More: How to Select Every Other Column in Excel


Keyboard Shortcut to Select Column with Data in Excel

Often we might feel the need to select an entire column with data instead of the whole column. In that situation-

Steps:

  • Presently, choose any cell (D14) from the column that you want to select.
  • Then, press the CTRL + SHIFT + ↑ keys from the keyboard.

Keyboard Shortcut to Select Column with Data in Excel

  • Just like the following screenshot, the entire specific column with data will be selected.

Keyboard Shortcut to Select Column with Data in Excel


How to Select Entire Row in Excel

In addition to the ways of selecting an entire column, let’s also learn about selecting an entire row with a simple keyboard shortcut.

Steps:

  • Similarly, select a cell (C8) from any row.
  • Thereafter, click SHIFT + SPACEBAR to select the whole row.

How to Select Entire Row in Excel

  • In conclusion, the entire row will be selected within a blink of an eye.

Read More: How to Select Specific Columns in Excel 


Things to Remember

If you are using Mac then you can press COMMAND + SPACE to select an entire column in Excel.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Conclusion

In this article, I have tried to cover all the methods to select an entire column in Excel. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience.

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Wasim Akram
Wasim Akram

Wasim Akram, BSc, Industrial and Production Engineering, Ahsanullah University of Science & Technology, has been working with the ExcelDemy project for 10 months. Currently working as as Excel and VBA content developer who provides authentic solutions to different Excel-related problems and writes amazing content articles regularly. He published almost 150 articles and has many more coming. He is very passionate about learning new things about Microsoft office Suite and Data analysis.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo