This illustrated walk-through (with a demo worksheet) shows how easy it is to create a multi-column search solution using validation lists and conditional formatting.

Excel offers two types of column headings; the letters the Excel assigns to each column, which you can toggle in both view and print modes, or the headings that you create yourself and place in ...

How to create an Excel table 1. First, enter the field names in the columns across the top, and then enter some records/data in the rows under each column.

Why Grouping Is Better Than Hiding Before I show you how to create column groups in Excel, let me explain the many benefits of using this method over hiding and unhiding columns.

To create a more consistent look in your worksheet, set a default column width. Default width is applied to all columns in the entire project, so the space within each column is the same.

You can combine two columns in Excel using several formulas and tools available in the software. Here's how to combine two columns in Excel.

In this post we show you how to create a Bar Graph or Column Chart in Excel. Bar graphs could be both 2-D or 3-D depending on the editor you use.

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.

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.