Excel VBA to Clear Manual Page Breaks
When clearing page breaks in Excel VBA you need to be careful. There is one command that will clear page breaks but it will also affect other print settings.
(more…)Relative and Fixed Reference Trick in Excel
When creating ranges of formulas that you want to copy down, you sometimes have a trade off in the use of fixed and relative references. If you need to create a relative reference that acts like a fixed reference you can use a trick. (more…)
Filter in Power BI Data View
Filtering coming soon to the Data view in Power BI. Fingers crossed this gets done soon - patience everyone.
Dates are Easy with Power Query
You can create complex functions with Excel to handle dates. But it makes more sense to get your data structured correctly and then you can use simpler date formulas. Power Query allows you to fix your data so that you can use those simpler formulas. (more…)
Copy Across Shortcut
In the structure below let's assume you want to copy the SUM formula from cell B5 to cell C5. Obviously you could use copy and paste, but that would require a few keyboard presses or mouse clicks. Given that we already have cell C5 selected we can use Ctrl + Shift + > This copies whatever is in the cell on the left to the current cell.
Following Links in Excel
Excel has a shortcut that allows you to follow a link to its source but it has a limitation find out how to get around that limitation. (more…)