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 …
MAKEARRAY function - Microsoft Support
Returns a calculated array of a specified row and column size, by applying a LAMBDA function
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 …
Create columns of text in a text box or shape - Microsoft Support
Select Columns, enter the number of columns in the Number box, and the space between each column (in inches) in the Spacing box. If the Columns button is grayed out, it's likely because …
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 …
Create a relationship between tables in Excel - Microsoft Support
Although Excel can tell you when a relationship is needed, it can't tell you which tables and columns to use, or whether a table relationship is even possible. Try following these steps to …
Filter data in a range or table in Excel - Microsoft Support
Use AutoFilter or built-in comparison operators like "greater than" and "top 10" in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can …
Create a PivotTable to analyze worksheet data - Microsoft Support
How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.
Create a list of sequential dates - Microsoft Support
You can quickly create a list of dates, in sequential order, by using the Fill Handle or the Fill command.
Using structured references with Excel tables - Microsoft Support
When you create an Excel table, Excel assigns a name to the table, and to each column header in the table. When you add formulas to an Excel table, those names can appear automatically as …