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 default method for including a column reference in an Excel formula is to use the column letter, a convention that may make it difficult to interpret the parts of complex formulas. Microsoft ...

The Freeze feature in Excel allows you to scroll down through hundreds of rows and still see the original headers or field names in row 1, or scroll over hundreds of columns and still see the data ...

Over the course of a long night, you prepared your spreadsheet. However, when you looked at it the next morning, you find that you cannot see several columns. Do not worry -- Excel did not ...

You can easily hide columns when working within an Excel spreadsheet — and just as easily unhide them. Excel is great for sorting large amounts of data, whether it involves alphabetizing, adding, or ...

Google Sheets is getting a few new features, including improvements for handling Microsoft Excel spreadsheets.