How to Select Column in Excel (6 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

In this article, you will find various methods on how to select column in Excel. You will find the way of selecting column using one click as well as using keyboard shortcut. Besides, you will be capable of selecting contiguous as well as non-contiguous columns in Excel. Moreover, you will find a method to automatically select columns in Excel.

There are a lot of reasons to select columns in Excel. Firstly, you may need to apply specific formatting in the column. Besides, if you want to sort data in a column or analyze the data, you have to select the column. There are a lot of other reasons that’s why you need to select a column. Whatever the reason, follow the article below and apply the techniques in your worksheet.

How to Select Column in Excel

Download Practice Workbook

You may download the following workbook to practice yourself.

How to Select Column in Excel: 6 Easy Ways

1. Select Entire Column (Single) Using Keyboard Shortcut

1.1 Select Column in One Click

This is the shortest way to select one entire column. Just click on the column header like the following image.

Select Column Using Mouse Click

1.2 Select Column Using Keyboard Shortcut

When you are working with Excel, you may need to select the present column where you are working or modifying some data.

  • To do that, select any of the cells in the column where you are working.
  • Then, press Ctrl+Spacebar together to select that specific column. You are done!

Selecting Column Using Keyboard

2. Select Multiple Columns in Excel

2.1 Select Contiguous Columns Using the Mouse

When you are comfortable working with the mouse, you may use it to choose multiple columns too.

  • First, click on the column header of the first column. We need to select Column C, Column D, and Column E. So, we will click on the header of Column C.
  • Hold the left mouse button and drag the mouse right up to Column E.

Select Multiple Columns Using Mouse

Note: You could do the same thing by selecting Column E first. To do that, you need to move the mouse left to select the left columns.

2.2 Select Contiguous Columns Using the Keyboard Shortcut

Using a keyboard shortcut to select multiple columns is more convenient than other methods.

  • In the beginning, select at least one cell from each of the columns that you need to select.

Selecting Cells in Each Targeted Column

  • After that, press Ctrl+Space together to select the columns.

Selected Column Using Keyboard Shortcut

2.3 Select Non-Contiguous Columns

In the previous methods, we focused on selecting contiguous columns. But, in this section, we will discuss how to select non-contiguous columns.

  • Select any column first by left-clicking the mouse.
  • Press and hold the Ctrl key and click column headers one by one.

Selecting Non-Contiguous Columns

3. Select Column Automatically Using Named Range

When you wish to choose columns automatically, you can do it by giving a specific name to those columns in the Define Names section under the Formulas tab.

  • To do that, click on the Formulas tab and then Define Name option in the Defined Names group.

Selecting Option to Select Column Automatically

  • After that, a dialog box named New Name will appear, prompting you to give the name of the selection and the selection as well.

Giving Name to Selection

  • After giving the name and closing the dialog box, click on the Name Box, where you will find an option Select_Auto.
  • Click on the option, and you will find that the specific column that you gave in the Refers to: box is selected.

Select Column Automatically

4. Select a Column in a Table

Selecting a column in a table is very similar to selecting a column in the normal process. The difference is instead of clicking on the column header, you will click on the table header.

  • Place your cursor on the table header of the desired column. We want to select the Management column. So, we put the cursor on cell E4.

Cursor Placement to Select Colum in Table

  • Now, just click on the header, and you will be able to select a column.

Selecting Column in a Table

Note: You will not be able to select the column unless the cursor converts into a downward arrow. So, ensure first that this is selected in a table.

5. Select Column in a Pivot Table

If you know how to select a column in a table, then it will be very easy for you to choose a column in a pivot table. In the following image, you will see a pivot table where we will select a certain column.

Pivot Table in Excel

We will select the Average of History column. So, we will put the cursor on C4 and click on it as you see in the following image.

Selecting Column in a Pivot Table

Note: Select multiple columns by holding Ctrl key and selecting columns one by one.

6. Use a VBA Code to Select Desired Column

You can select columns easily by running a VBA code. In the following section, you will find a VBA code that will select your desired columns in your worksheet.

  • Press Alt+F11 together to open the VBA Editor.
  • Under the Insert tab, click on the button Module.

Creating New Module in VBA Editor

  • Copy the following VBA code.
Sub Select_Columns()
Range("B1, F1").EntireColumn.Select
End Sub
  • Now, paste the code in the editor and save it.

Code to Select Columns

  • Go back to the Excel workbook and select the whole data table.
  • Press Alt+F8 together to open the macro window, where you will select the Select_Columns code and hit Run.

You will get the following output in your worksheet.

Output of Selecting Columns Using VBA Code

How to Select Row in Excel

The process of selecting a row in Excel is very similar to selecting a column in Excel.

  • Select any cell in the row.
  • Press Shift+Spacebar together to select the entire row.

How to Select Row in Excel

Read More: Select Specific Columns in Excel

Things to Remember

  • If you are a Mac user, use the Command key instead of the Ctrl key.
  • You can convert the process of selecting column automated by using a VBA code.
  • Selecting rows in Excel is very similar to the process of selecting columns. Just alter the Ctrl key with the Shift key.

Frequently Asked Questions

1. How do I select specific text in Excel?

You can use the Find & Select option in the Editing group of the Home tab.

2. How do I select data in Excel?

You can use the keyboard shortcut Ctrl+A to select all data in Excel.

3. How can I select multiple rows using Name Box?

The format to select multiple rows using Name Box is: X:Y; where X and Y represent the serial number of the column. For example, if you write 4:6 in the Name Box, all the cells in the range Row 4 to Row 6 will be selected.


Hey! You have reached the end of the article on how to select column in Excel. We have covered all the possible techniques of selecting columns by which you can make your work in Excel smooth. If you find this article helpful, please share it with your friends. Moreover, do let us know if you have any further queries. Finally, please visit our site for more exciting articles on Excel.

How to Select Column in Excel: Knowledge Hub

<< Go Back to Columns in Excel | Learn Excel

What is ExcelDemy?

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

Md Junaed-Ar-Rahman, a Biomedical Engineering graduate from Bangladesh University of Engineering and Technology, has contributed to the ExcelDemy project for one year. As a technical content developer, he has authored 15+ unique articles and actively addressed user problems. He participated in 2 specialized training programs on VBA and Chart & Dashboard design in Excel. His passion lies in solving problems uniquely and exploring new functions and formulas. Eager for future exploration, he aims to gain proficiency in applications... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF