Dynamic array formulas and spilled array behavior - Microsoft …
Formulas that can return arrays of variable size are called dynamic array formulas. Formulas that are currently returning arrays that are successfully spilling can be referred to as spilled array formulas. Following are some notes to help you understand and use these type of formulas.
Create, load, or edit a query in Excel (Power Query) - Microsoft …
When setting these options, Power Query doesn't change query results in the worksheet or the Data Model data and annotations. You can also dynamically override the default settings for a query by using the Import dialog box which displays after you select Close & Load To.
Use conditional formatting to highlight information in Excel
You can change the scoping method to the corresponding field or value field by using the Apply formatting rule to option button, the New Formatting Rule dialog box, or the Edit Formatting Rule dialog box.
Change the scale of the vertical (value) axis in a chart
To change the point where you want the horizontal (category) axis to cross the vertical (value) axis, under Floor crosses at, click Axis value, and then type the number you want in the text box.
Add or remove items from a drop-down list - Microsoft Support
If you set up your list source as an Excel table, then all you need to do is add or remove items from the list, and Excel will automatically update any associated drop-downs for you. To add an item, go to the end of the list and type the new item. To remove an item, press Delete.
About Power Query in Excel - Microsoft Support
With Power Query, you can search for data sources, make connections, and then shape that data (for example remove a column, change a data type, or merge tables) in ways that meet your needs.
Design the layout and format of a PivotTable - Microsoft Support
To change the layout of a PivotTable, you can change the PivotTable form and the way that fields, columns, rows, subtotals, empty cells and lines are displayed. To change the format of the PivotTable, you can apply a predefined style, banded rows, and conditional formatting.
Resize a table by adding or removing rows and columns
You can use the Resize command in Excel to add rows and columns to a table: Click anywhere in the table, and the Table Tools option appears. Click Design > Resize Table. Select the entire range of cells you want your table to include, starting with the upper-leftmost cell.
Switch between relative, absolute, and mixed references
Press F4 to switch between the reference types. The table below summarizes how a reference type updates if a formula containing the reference is copied two cells down and two cells to the right. Use absolute or relative cell references in formulas, or a mix of both.
Transpose (rotate) data from rows to columns or vice versa
If you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to rows, or vice versa.
Move or copy cells, rows, and columns - Microsoft Support
Move or copy just the contents of a cell. Double-click the cell that contains the data that you want to move or copy. You can also edit and select cell data in the formula bar. In the cell, click where you want to paste the characters, or double-click another cell to move or copy the data.