Excel Basics #18: Data Analysis Sort

The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#18 Video topics:
1)How to Sort a column of data
2)Sort button
3)Sort dialog box
4)Sort Left to Right
5)Excel List Table Database format is required for sorting
6)Sort A to Z
7)Sort Z to A
8)Sort Ascending
9)Sort Descending

Category:

Science & Technology

Tags:

• Excel
• How
• to
• Sort
• column
• of
• data
• Left
• Right
• sort
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[ishaq79]

I love ... sound you make while teaching ... zzzzzp... drrrrrooop

[ExcelIsFun]

@ishaq79 , cool! It does make it more fun!

[superbeast326]

How can I lock cells based on certain conditions?

[ExcelIsFun]

@superbeast326 , maybe if you wanted to lock F2 if column A had "Flat" in it, otherwise Relative Cell Reference, a formula of this type might work:

=IF(A2="Flat",$F$2,A2)

[superbeast326]

@ExcelIsFun lets say I have locked B3:B50 and kept B2 unlocked, I can use the above formula to unlock B3 the moment B2 is filled with data and so on and so forth for all cells until B50?

[ExcelIsFun]

@superbeast326 , I have no idea. Try posting to THE best Excel question site:

mrexcel [dot] com/forum

[SuperNancyCampbell]

Great job on the video.

I still use Excel and another database called Mybusybiz for my business.

[ExcelIsFun]

@superbeast326 , I do not know SQL, so I can't answer your Q. Sorry.

[ExcelIsFun]

@anomalytrade , I am glad that the videos help!

[superbeast326]

Is it possible to use mySQL queries with Excel?