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 …

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.

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 …

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.

In Excel, you may want to load a query into another worksheet or Data Model. In the list of queries, locate the query, right click the query, and then select Load To.

Use commas to separate the cells you are combining, use quotation marks to add spaces, commas, other text, or the ampersand symbol (&) with the next cell you want to combine.

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.

Insert a line break to start a new line of text or add space between lines of text in a cell in Excel.

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 …

To insert a horizontal page break, select the column to the right of where you want to insert the page break. On the Page Layout tab, in the Page Setup group, click Breaks.