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
Please use your cursor to select the columns you have
Excelchat Expert
05/08/2018 - 06:44
By left clicking your mouse
User
05/08/2018 - 06:44
Please tell me how to "select all columns"
Excelchat Expert
05/08/2018 - 06:45
Please hold your left click of your mouse then slide to the columns you have
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
Please left click your mouse and hold it
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
Please show me.
Excelchat Expert
05/08/2018 - 06:52
IN google sheet, please go to data--> turn on filter
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.