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 number of columns to the right of where you want to add new ones.
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 automatically sense the range to be summed. (AutoSum can also work horizontally if you select an empty cell to the right of the cells to be summed.)
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 budget, select cell B7, the cell immediately below the column of numbers.
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 rest of the column by itself. There’s no need to use the Fill or Copy commands.
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.
Insert or delete a worksheet - Microsoft Support
In Excel, you can easily insert, rename, and delete worksheets in your workbook. Insert a worksheet Select the New Sheet plus icon at the bottom of the workbook.
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 to your data.
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 editing, while leaving other cells locked, it's possible to unlock all the cells.
Resize a table by adding or removing rows and columns
Add a row or column to a table by typing in a cell just below the last row or to the right of the last column, by pasting data into a cell, or by inserting rows or columns between existing rows or columns.
Hide or show rows or columns - Microsoft Support
How to hide and unhide columns and rows in an Excel worksheet. Restrict access to only the data you want to be seen or printed.