Want to name a range in Microsoft Excel? This post shows how to edit or create Named Ranges in Excel using four methods.

Excel Tables offer a range of features for working with list-style data.

What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format ...

Excel Dependent Drop Down Lists Explained Named ranges are a crucial component of creating dependent drop-down lists in Excel.

An curved arrow pointing right. Here's a really easy setup for displaying data in Excel. The key is to create dynamic named ranges. Watch the video to see how to do it in just a few easy steps ...

Named ranges aren't just for formulas. Here are two ways you can use named ranges to create shortcuts for quick navigation in a Microsoft Excel workbook.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

An curved arrow pointing right. Here's a really easy setup for displaying data in Excel. The key is to create dynamic named ranges. Watch the video to see how to do it in just a few easy steps ...

You can use a menu command to create a hyperlink to a named range or you can use a simple drag-and-drop trick.

How to Create Progression in Excel With Alphabets. Microsoft Excel can use the contents of a cell range to populate adjacent cells. If a range of cells contains a progressive series of numbers ...