troubleshooting Question

Simulate Word Columns In Excel

Avatar of Eirman
EirmanFlag for Ireland asked on
Microsoft ExcelMicrosoft Office
6 Comments1 Solution12 ViewsLast Modified:
If I create a 3 column Word document and populate it with one text item per line,
I can sort all 3 column as one, with one single Sort A-Z click.

I want to do the same in Excel with three columns A1:C50
(There are no formulae and nothing will be entered outside A1:C50)
How do I make excel ignore row 51 and below?
How do I 'link' A50 to B1 and B50 to C1 for sorting purposes?

In the attached 5 row demo sheet .....
If I add "ARCHIE" into C3 and then A-Z sorting is implemented
ARCHIE would be sorted to the A4 position and JACK would move down to C3

Why do I want to do this you may ask .... I need to see 100+ alphabetically sorted text items
on my monitor without scrolling with the ability add, remove and re-sort items. 

3 Column Sorting.xlsx
If you could add an A-Z sort button that would be brilliant!
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros