Insert or delete rows and columns - Microsoft Support
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 …
Use AutoSum to sum numbers in Excel - Microsoft Support
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.
Resize a table by adding or removing rows and columns in Excel
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 …
Use calculated columns in an Excel table - Microsoft Support
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.
Add a list of numbers in a column - Microsoft Support
To add a list of numbers, select the cell below a column of numbers, and then click AutoSum.
Combine text from two or more cells into one cell in Microsoft Excel
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.
Ways to count values in a worksheet - Microsoft Support
Excel provides multiple techniques that you can use to count cells, rows, or columns of data. To help you make the best choice, this article provides a comprehensive summary of methods, a …
Insert subtotals in a list of data in a worksheet - Microsoft Support
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 …
Subtotal and total fields in a PivotTable - Microsoft Support
When working with a PivotTable, you can display or hide subtotals for individual column and row fields, display or hide column and row grand totals for the entire report, and calculate the …
Add a custom column (Power Query) - Microsoft Support
With Power Query, you can add an Index or Custom (you define the formula) column to your current query.