Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

How to Make a List in Excel for Mac. ... Click and drag the cursor down the column of cells while holding down the mouse button. Create your own custom lists for Excel to automatically fill.

Thankfully, it’s easy to hide a row, or hide a column in Excel. Just right-click it, then select Hide. ... Excel will automatically copy the formula and fill in appropriately.