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-
- 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.
- As you can see, we have successfully chosen the entire column in our worksheet.
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.
- 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.
- 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,
- 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.
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-
- First, choose a column (C) and drag the mouse toward another column when the Handle icon appears.
- 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
- Similarly, choose any column (C) and hold the CTRL key from the keyboard.
- While holding the CTRL key choose any column of your choice and it will be selected for further editing.
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-
- First, choose any column (E) and click the Define Name option from the Formulas feature.
- 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.
- 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.
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-
- Presently, choose any cell (D14) from the column that you want to select.
- Then, press the CTRL + SHIFT + ↑ keys from the keyboard.
- Just like the following screenshot, the entire specific column with data will be selected.
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.
- Similarly, select a cell (C8) from any row.
- Thereafter, click SHIFT + SPACEBAR to select the whole row.
- 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.
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.