Power users rely on these lesser-known Excel shortcuts to work faster across large datasets, formulas, and worksheets.

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

How to create an Excel drop down list from another tab Your email has been sent The data you want to use in an Excel drop down list usually won’t be in the same sheet as the drop down. The good news ...

When you type data into an Excel workbook, the sheet's name appears in a tab at the bottom of the application window. When you edit the page code, the name isn't always so obvious. Although the Visual ...

While Microsoft Excel is one of the most powerful spreadsheet applications, it’s also the most intimidating tool in the Microsoft Office suite. If you’ve never used Excel before or are just a bit ...

In the January column (page 82) a reader asked how to display 36 workbook tabs in Excel. We described several solutions, but reader Mary Jo Gruber, a CPA with a St. Louis public school district, ...

When working with more than one sheet, it’s a good idea to give those sheets meaningful names. Doing so improves efficiency, from the simple task of clicking the right sheet to referencing sheets in ...