Excel - COLUMN Function Problem - Expert Solution

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

For some reason all of the column identifiers (a,b,c,etc.) are green but only rows 1-12 are and when I go to organize the sheet the green rows are the only ones organized.... ( by way of filter header) I removed all formatting on the sheet but it didn't seem to make any difference. There is a thin green line between rows 12 and 13 that I cannot move or get rid of.
Solved by X. J. in 13 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 03/08/2018 - 04:42
Welcome, thank you for choosing Got It Pro-Excel! I'll be glad to assist you with your concern. :)
User 03/08/2018 - 04:42
Thank you
Excelchat Expert 03/08/2018 - 04:43
Okay, I see. Basically, you need help with a table you're working with that has filters and cell formats on. Will it be okay if you can share the file you're working on so we could better grasp the situation? Thanks!
User 03/08/2018 - 04:44
It has confidential contact info on it...
Excelchat Expert 03/08/2018 - 04:45
Oh I see. Hmmm. How about if you can clear the cells with confidential info on it. I just wish to see how the data set is structured so that I can provide more specific instructions once I've analyzed it. :)
Excelchat Expert 03/08/2018 - 04:51
Okay, it seems you've entered some sample data on the document preview. I do have some clarifications by the way. Are you working on Google sheets or Excel? :)
User 03/08/2018 - 04:51
google sheets
Excelchat Expert 03/08/2018 - 04:52
Noted on that. It seems the filter in your original file is then not configured properly. Let me provide specific steps to remedy this concern.
Excelchat Expert 03/08/2018 - 04:52
1. click on any cell in your data set.
Excelchat Expert 03/08/2018 - 04:52
2. Go to the Data menu and select "Turn off filters"
User 03/08/2018 - 04:53
now the green is gone
Excelchat Expert 03/08/2018 - 04:53
Let me know if you're able to turn off the filters.
Excelchat Expert 03/08/2018 - 04:53
Excelchat Expert 03/08/2018 - 04:54
Okay, next thing is to select all your data. Let me know when you're done.
User 03/08/2018 - 04:54
ok all good now thank you so much
Excelchat Expert 03/08/2018 - 04:54
Nice! You can now end the session via the button on your upper right (sorry, can't do it from our end). I would also appreciate it if you can leave a great feedback after this.Thanks so much for using Got it pro and have a nice day! :)

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc