# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need to create a spreadsheet in excel with about 6 columns where I can get the first column alphabetized and the content of the other columns moves with the content of the 1st column.
Solved by D. F. in 35 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 05/08/2018 - 06:28
Hello! Welcome to got it pro!
User 05/08/2018 - 06:28
Hello.
Excelchat Expert 05/08/2018 - 06:29
I saw that you are trying to create a spreadsheet
Excelchat Expert 05/08/2018 - 06:29
And based on the value of column A, other column change as well
Excelchat Expert 05/08/2018 - 06:29
Is that correct?
User 05/08/2018 - 06:30
Yes.
User 05/08/2018 - 06:30
I wanted to put a header on the 1st line of each column but be able to alphabetize column A with the other info following the line.
Excelchat Expert 05/08/2018 - 06:31
Something like this?
User 05/08/2018 - 06:32
So how d
User 05/08/2018 - 06:33
So how can I alphabetize column 1 and have the other columns adjust with it?
Excelchat Expert 05/08/2018 - 06:34
Well, you can apply a filter
Excelchat Expert 05/08/2018 - 06:34
Then filter it from A-> Z
Excelchat Expert 05/08/2018 - 06:34
then all columns will be adjusted automatically
User 05/08/2018 - 06:34
How do I put the header on line 1 and not have that be alphabetized?
Excelchat Expert 05/08/2018 - 06:35
Current filter will not filter the head line by default
User 05/08/2018 - 06:36
When I selected "insert table" and gave the lines a header it wouldn't alphabetize all the info
User 05/08/2018 - 06:36
I guess I'm getting confused by the words being used, "filter" "header"
Excelchat Expert 05/08/2018 - 06:37
Filter is a functional that you can apply to all columns
Excelchat Expert 05/08/2018 - 06:37
Header represent the first row that you will used
User 05/08/2018 - 06:40
So, when I create a new spreadsheet please tell me how to do this, I am getting so frustrated because I have created them, then tried to get my work alpha but none that I have done will do what I want. They either alpha everything including what I want on the header line or they only alpha the 1st column and not the other columns info.
Excelchat Expert 05/08/2018 - 06:41
You will select all columns and then select the filter options and then sort the columns that you need
Excelchat Expert 05/08/2018 - 06:41
Then all other columns will be automatically sorted based on the column you just sorted
User 05/08/2018 - 06:42
I don't understand, I just create a new blank spreadsheet, type in my info, then what, what does that mean, "Select all columns"?
Excelchat Expert 05/08/2018 - 06:43
Before you apply filters, you will need to select all columns that you have your input
Excelchat Expert 05/08/2018 - 06:43
then the filter will include all columns that you have
Excelchat Expert 05/08/2018 - 06:43
In this example, once you select column A to D
Excelchat Expert 05/08/2018 - 06:43
Then apply filter, the filter will inlcude A to D
User 05/08/2018 - 06:43
How do I "select all columns"? What does that mean?
Excelchat Expert 05/08/2018 - 06:44
Excelchat Expert 05/08/2018 - 06:44
User 05/08/2018 - 06:44
Please tell me how to "select all columns"
Excelchat Expert 05/08/2018 - 06:45
Excelchat Expert 05/08/2018 - 06:45
in this case A to D
User 05/08/2018 - 06:46
I don't understand what you are saying. Do you mean that I can click on A then hold down the shift button and select the other columns?
Excelchat Expert 05/08/2018 - 06:47
No,
Excelchat Expert 05/08/2018 - 06:47
Excelchat Expert 05/08/2018 - 06:48
2. slide and include all columns that you have
Excelchat Expert 05/08/2018 - 06:48
In this case A to D
Excelchat Expert 05/08/2018 - 06:48
Then it will include all columns
User 05/08/2018 - 06:49
Let's suppose I know what you are saying and have selected the columns I want, then what?
Excelchat Expert 05/08/2018 - 06:50
Select the data you want to filter. For best results, the columns should have headings.
Excelchat Expert 05/08/2018 - 06:50
Click the arrow Filter arrow in the column header, and then click Text Filters or Number Filters.
Excelchat Expert 05/08/2018 - 06:50
Then please select the option filter from A to Z
User 05/08/2018 - 06:51
Excelchat Expert 05/08/2018 - 06:52
User 05/08/2018 - 06:52
When I inserted a table and selected header it put an arrow at the top of every column
Excelchat Expert 05/08/2018 - 06:52
Yes
Excelchat Expert 05/08/2018 - 06:52
Then please sort from A to Z
User 05/08/2018 - 06:53
What does this mean? IN google sheet, please go to data--> turn on filter
Excelchat Expert 05/08/2018 - 06:54
This platform is based on google sheet
Excelchat Expert 05/08/2018 - 06:54
Not MS excel
User 05/08/2018 - 06:54
When I put a header on the top of each column it would alpha column a but not move the other info.
Excelchat Expert 05/08/2018 - 06:54
Does the filter applied to all columns?
User 05/08/2018 - 06:55
I typed that I wanted help with excel, I don't know what google sheet is.
User 05/08/2018 - 06:55
Why is this called "excelchat" if you are not helping me with excel??
Excelchat Expert 05/08/2018 - 06:56
On the Data tab, in the Sort & Filter group, click Filter.
Excelchat Expert 05/08/2018 - 06:56
Click the arrow Filter drop-down arrow in the column header to display a list in which you can make filter choices.
Excelchat Expert 05/08/2018 - 06:56
Excel is a application
Excelchat Expert 05/08/2018 - 06:56
Googe sheet is also a excel application
Excelchat Expert 05/08/2018 - 06:56
We are here to help people and not to confuse anyone for sure!
User 05/08/2018 - 06:57
I'm sorry I wasted your time, I need help with my excel spreadsheet in the MS Excel on my computer. I don't want to use google sheet.
Excelchat Expert 05/08/2018 - 06:58
Well, the instruction that I sent you earlier is exactly for MS excel
Excelchat Expert 05/08/2018 - 06:58
If you can spend sometime read it, you will definitely understand what it does
User 05/08/2018 - 07:01
Thank you. The biggest problem I have most of the time is that the instructions start with something like, "go to (fill in the blank), then here is the step by step. The problem is I don't know how to get to (fill in the blank) to begin with so the step by step are useless until I actually get to that place. It's like giving someone directions to a building in New York city from California but not telling them how to get to New York from California.

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.