One of the most underused lookup and reference functions in Microsoft Excel is the DROP function. This powerful yet simple ...

Sorting is one of Microsoft Excel's easiest tasks. Click; you're done! At least until you need to sort by multiple columns. For this sort task, you'll need a custom sort. Here's how. Explore Get the ...

The best way to do this is by converting your data to an Excel table. Select your data range (A1:E11), press Ctrl + T, and click OK. Excel names it something like "Table1"; in my case, it's Table3, ...

Have you ever tried to drag the header columns in an Excel spreadsheet to make them fit the text? I have and just when I think I’ve got it right, a quick glimpse down the line of columns usually ...