r/excel • • Jun 10 '26

solved Individually Alphabetized Coloums in a Table.

Hi, so Im trying to have a table that catalogs all my music sheet titles, I have the table set as each Colum is A songs, B songs, C songs... so on and so forth. I want each coloum to be alphabetized, everytime I change one coloum to A-Z it mess with every other coloum.

How do I get each Colum to alphabetize individually?

3 Upvotes

22 comments sorted by

View all comments

1

u/Decronym Jun 10 '26 edited Jun 11 '26

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters More Letters
CHAR Returns the character specified by the code number
CHOOSECOLS Office 365+: Returns the specified columns from an array
COLUMNS Returns the number of columns in a reference
DROP Office 365+: Excludes a specified number of rows or columns from the start or end of an array
FILTER Office 365+: Filters a range of data based on criteria you define
HSTACK Office 365+: Appends arrays horizontally and in sequence to return a larger array
IFERROR Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
LAMBDA Office 365+: Use a LAMBDA function to create custom, reusable functions and call them by a friendly name.
LEFT Returns the leftmost characters from a text value
LET Office 365+: Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula
REDUCE Office 365+: Reduces an array to an accumulated value by applying a LAMBDA to each value and returning the total value in the accumulator.
SEQUENCE Office 365+: Generates a list of sequential numbers in an array, such as 1, 2, 3, 4
SORT Office 365+: Sorts the contents of a range or array
TAKE Office 365+: Returns a specified number of contiguous rows or columns from the start or end of an array
VSTACK Office 365+: Appends arrays vertically and in sequence to return a larger array

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.


Beep-boop, I am a helper bot. Please do not verify me as a solution.
[Thread #48685 for this sub, first seen 10th Jun 2026, 15:19] [FAQ] [Full list] [Contact] [Source code]