Sync your drop-down menus with table headers using this robust, auto-expanding Named Range trick.

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 ...

In Microsoft Excel, there are row and column headings on your spreadsheet by default. The column header is the grey color alphabetical columns above the spreadsheet, and it identifies each column, ...

Replace manual Excel tasks with conditional columns, smart merging, the unpivot tool, and more.

When you add or subtract currency-formatted numbers, Excel 2013 automatically adopts the currency format for the results. Adding and subtracting figures follows similar procedures, but you must be ...

Hide everything but the working area in an Excel worksheet Your email has been sent If you’ve ever opened a Microsoft Excel workbook to find no columns, rows and/or scrollbars, this is probably why: ...

The battle of Word vs. Google Docs is usually over before it begins, with the spoils awarded to Microsoft’s venerable word processor and its huge feature set. But the size of the toolbox isn’t always ...

Each Microsoft Excel worksheet is broken up into cells. Each cell is part of a column. Excel's myriad formatting tools let you add colors, formulas and borders almost anywhere in a worksheet. You can ...