Merged cells break sorting and tables—use a macro to apply Center Across Selection with one click instead.

As PCMag's resident data journalist, I practically live in Microsoft Excel. I've learned that it's capable of far more than I ...

The Wrap feature wraps text into multiple lines so that you can see all of it, meaning that if there is a sentence in a cell which starched across the column to other columns in the spreadsheet, you ...