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

You can shift Cells Down in Excel by right-clicking, clicking and dragging, via the Home tab, using Shift-Click-Drag, Right-click and drag, Inserting copied cells, or by inserting a row. Let us take a ...

In this tutorial, we will show a simple trick to show charts with hidden data in Excel. Microsoft Excel is quite useful for analyzing trends and patterns in large data, It is easy to lay, reformat, ...

In this video, you’ll learn how to sort names by last name in Excel, even when first and last names are in the same cell. We walk through simple methods using built-in Excel tools to organize your ...

Importing data into Excel from other sources can a real headache, especially if you’re copying and pasting from an Internet source. Data that’s exported from a mainframe; from another program such as ...

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets. An Excel ...

Conditional formatting tricks: Sum values in Excel by cell color Your email has been sent When you think VBA code is your only hope, try combing built-it conditional formatting tools. You might just ...

Please note: This item is from our archives and was published in 2018. It is provided for historical reference. The content may be out of date and links may no longer function. Q. In Excel, is it ...