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 number of …

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.

To insert a column, pick any cell in the table and right-click. In the example shown below for rows, a row will be inserted above row 3. For columns, if you have a cell selected in the table's rightmost column, …

On the worksheet that contains your chart data, in the cells directly next to or below your existing source data for the chart, enter the new data series you want to add.

One quick and easy way to add values in Excel is to use AutoSum. Just select an empty cell directly below a column of data, then on the Formula tab, select AutoSum > Sum.

The Subtotal command will appear grayed out if you are working with an Excel table. To add subtotals in a table, you must first convert the table to a normal range of data, and then add the subtotal.

Use AutoFilter or built-in comparison operators like "greater than" and "top 10" in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a …

Insert a new column into the table. You can do this by typing in the column immediately to the right of the table, and Excel will automatically extend the table for you.

Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities. See Also Fill data automatically in worksheet cells

Check boxes are a versatile feature in Excel, useful for making interactive lists and forms. In this article, we'll cover how to add, remove, and toggle them. Insert check boxes Select the range where you …