How to Select Column to End of Data in Excel (3 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

This tutorial will demonstrate how to select a column to end of data in excel. When dealing with lots of data, we have to use the data from the first to the last cell. We must move from the first to the last data cell as fast as possible to ease our work. So, it is essential to learn how to select the column to the end of data in excel.


Download Practice Workbook

You can download the practice workbook from here.


3 Easy Methods to Select Column to End of Data in Excel

We’ll use a sample dataset overview as an example in Excel to understand easily. In this case, we have the Name in column B, ID in column C, EEE, ME, and CE in columns D, E, and F. If you follow the steps correctly, you should learn how to select a column to the end of data in excel on your own. The methods are:

excel select column to end of data


1. Using Keyboard Shortcut

In the beginning, we will try to select a column at the end of the data by using excel Keyboard Shortcuts. We can do this in the following two ways:

1.1 From Starting of Data

In this case, our goal is to select a column at the end of the data from the starting of the data by using keyboard shortcuts. The steps of this method are.

Steps:

  • First, select the desired cell (in this case cell B4).

  • Next, press the Ctrl+Shift+Down Arrow buttons and get the desired result.

Use Keyboard shortcuts to select column to end of data


1.2 From Ending of Data

Now, we can select column data from the very ending position of the data. We can do this by following the below steps.

Steps:

  • At first, select the last data cell of the desired workbook.

  • Then, press the Ctrl+Shift+Up Arrow buttons and get the desired result.

Pressing the Ctrl+Shift+Up Arrow buttons to select column to end of data

  • But in any case, you want to select cells towards the left side then, press the Ctrl+Shift+Left Arrow buttons and get the desired result.

Pressing the Ctrl+Shift+Left Arrow buttons to select column to end of data

Read More: How to Select Cells in Excel Using Keyboard (9 Ways)


2. Utilizing Go To Dialog Box

Next, we will try to select the column at the end of the data by utilizing the Go To dialog box. The steps of this method are.

Steps:

  • To begin with, select any cell of the data and press the Ctrl+G buttons at the same time.

Press the Ctrl+G buttons to select column to end of data

  • In addition, the Go To dialog box will appear on the screen.
  • Then, in the Reference section select the desired cell range and press OK.

Utilizing Go To dialog box to select column to end of data

  • Finally, you will get the desired result.

Read More: How to Go to Last Non Empty Cell in Column in Excel


Similar Readings


3. Applying VBA Code

In this case, we aim to select a column to end the data using VBA code. The steps of this method are described below.

Steps:

  • Firstly, go to the Insert > Module options to open the VBA window.

  • Secondly, insert the following code in the window.
Sub select_column_to_end_of_data()
Range("C1048576").End(xlUp).Select
Range(Cells(4, 6), Selection).Select
End Sub

Inserting VBA Code to select column to end of data

  • Lastly, after pressing the Run or F5 option, you will get the desired result.

Read More: Excel VBA to Protect Sheet but Allow to Select Locked Cells (2 Examples)


How to Select All Data in Excel

Our aim is to select all the cells of the workbook. The steps of this method are.

Steps:

  • At first, click on the Select All option on the left side of the bar or press the Ctrl+A buttons.

  • Then, you will get the desired result.

Read More: Select All Cells with Data in a Column in Excel (5 Methods+Shortcuts)


Things to Remember

  • In the first method, we can use the keyboard shortcut to starting point or ending point. But, the shortcut from the ending point is recommended as you already know the start. It helps to work easily.
  • By using the Go To dialog box, you can select any desired cell range.
  • Among all the methods, the first two methods are a little consuming to execute but using the VBA code is the easiest and fastest way.

Conclusion

Henceforth, follow the above-described methods. Hopefully, these methods will help you to select the column to the end of data in excel. We will be glad to know if you can execute the task in any other way. Follow the ExcelDemy website for more articles like this. Please feel free to add comments, suggestions, or questions in the section below if you have any confusion or face any problems. We will try our best to solve the problem or work with your suggestions.


Related Articles

Zehad Rian Jim

Zehad Rian Jim

Hi there! I am Zehad Rian Jim. I graduated with a bachelor's degree in engineering from BUET. Currently, I am working as a technical content writer at ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include watching movies, tv series, and meeting new people. I also enjoy sports. My favorite sports are Cricket (to watch and play) and Badminton (play).

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo