How to Use Flash Fill in Excel
Flash Fill is an Excel feature that intelligently spots patterns in your data to fill a range of cells. It can be used for things like: The process is: As an alternative to step 2, type a second entry for…
-
-
Highlight Row Blocks in Excel
Excel Tables has a Banded Rows option that highlights rows in alternating colours. This enhances readability by making it easier to differentiate between them. What if you wanted to highlight blocks of rows though? A conditional formatting rule combining the…
-
Consolidate Data with 3D References
3D references provide a simplified way of aggregating data by referring to the same cell or range across multiple worksheets. Say you had monthly sales figures stored in separate worksheets and wanted to summarise them. You might be tempted to…
-
Percentage Examples
Percentages are calculated for many things, such as interest rates, income tax, profit margins, restaurant bills, and possession in football matches. There are three main percentage calculations; each is shown in the document. Percentage of Total (Page 1) The exam…
-
How to Copy the Excel Status Bar Statistics
Excel’s status bar shows various statistics based on the values in the selected cell range (e.g. sum, average, max and min). Right-clicking on it opens the Customize Status Bar menu where you can choose what is featured. Microsoft stealthily snuck…
-
Keyboard Shortcut for VBA Comments
VBA lacks a keyboard shortcut for commenting. This is a standard feature in modern IDEs, however, the VBA Editor is not modern, so we are forced to tolerate its drawbacks. Comments are denoted using a single quotation mark (‘). Block…
End of content
End of content