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 …
Lock or unlock specific areas of a protected worksheet
How to lock cells in Excel to protect your data. You can also unlock a range of cells and grant permissions to others to edit.
Transpose (rotate) data from rows to columns or vice versa
If you want to rotate your data frequently to view it from different angles, consider creating a PivotTable so that you can quickly pivot your data by dragging fields from the Rows area to the …
Freeze panes to lock rows and columns - Microsoft Support
To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can …
Change the column width and row height - Microsoft Support
How to change the column width and row height, including how to use the AutoFit feature, in your Excel worksheet.
Split data into multiple columns - Microsoft Support
Power Query splits the Sales Rep names into two different columns named "Sales Rep 1" and "Sales Rep 2". To change the default names, rename them to "Sales Rep First" and "Sales …
Combine text from two or more cells into one cell in Microsoft Excel
Combine data in Excel using the CONCAT function Select the cell where you want to put the combined data. Type =CONCAT (. Select the cell you want to combine first. Use commas to …
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 …
Repeat specific rows or columns on every printed page
If a worksheet spans more than one printed page, you can label data by adding row and column headings that will appear on each print page. These labels are also known as print titles.
Sort data in a range or table in Excel - Microsoft Support
How to sort and organize your Excel data numerically, alphabetically, by priority or format, by date and time, and more.