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 …
Ways to add values in a spreadsheet - Microsoft Support
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, click AutoSum > Sum. Excel will …
Use AutoSum to sum numbers - Microsoft Support
When you select AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. Here’s an example. To add the January numbers in this Entertainment …
Use calculated columns in an Excel table - Microsoft Support
Calculated columns in Excel tables are a fantastic tool for entering formulas efficiently. They allow you to enter a single formula in one cell, and then that formula will automatically expand to the …
Lock or unlock specific areas of a protected worksheet
Applies To Excel for Microsoft 365 Excel 2024 Excel 2021 Excel 2019 Excel 2016 By default, protecting a worksheet locks all cells so none of them are editable. To enable some cell …
Outline (group) data in a worksheet - Microsoft Support
Use an outline to quickly display summary rows or columns, or to reveal the detail data for each group. You can create an outline of rows (as shown in the example below), an outline of …
Create a simple formula in Excel - Microsoft Support
How to create simple formulas in Excel using AutoSum and the SUM function, along with the add, subtract, multiply, or divide values in your worksheet.
Combine text from two or more cells into one cell
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.
Apply shading to alternate rows or columns in a worksheet
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 …
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 …