Use Excel's "Freeze Panes" functionality to lock rows or columns in place. Use Excel sort features to organize data in alphabetical or numerical order.

Not all sorts in Excel are alphabetical. Sometimes, you need to sort by an irregular set of terms, and when that happens, you need to create a custom sort. Here's how.

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting. Data bars are a kind of conditional formatting, with the bar length based on the value of the ...