When you try to sort by person in charge, it stops with the error, "The merged cells must be identically sized." Even if the ...

For many of us, sorting an Excel spreadsheet alphabetically means clicking the A→Z or Z→A buttons in the Sort & Filter group and moving on with our day. I used to think that was the extent of what ...

You want to sort amounts in ascending order. If you lose track of which name or number corresponds to which amount, the table becomes useless. When sorting, you must distinguish between 'what to sort ...

It's often useful to freeze header rows in place in Microsoft Excel to remember what type of data is in various columns as you scroll or search through a lengthy spreadsheet. You can also make sure ...