You can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define.

To insert a single column: Right-click the whole column to the right of where you want to add the new column, and then select Insert Columns. To insert multiple columns: Select the same …

Select a range of data, such as A1:L5 (multiple rows and columns) or C1:C80 (a single column). The range can include titles that you created to identify columns or rows.

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

After you create a drop-down list, you might want to add more items or delete items. In this article, we'll show you how to do that depending on how the list was created.

Here's how: Select the range of cells that you want to format. Go to Home > Format as Table. Pick a table style that has alternate row shading. To change the shading from rows to …

If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, select AutoSum on the Home tab, press Enter, and you're done.

Parts of this article were based on a series of Excel Power User columns written by Colin Wilcox, and adapted from chapters 14 and 15 of Excel 2002 Formulas, a book written by John …

How to use the SUMIF function in Excel to add the values in a range that meet criteria that you specify.

There are two ways to apply shading to alternate rows or columns —you can apply the shading by using a simple conditional formatting formula, or you can apply a predefined Excel table style …