Excel Tips
August 11, 2017
In the last episode, Ctrl+T made the pivot table source expand
Excel Shortcuts - Show Formulas »
August 11, 2017
Sure, you can see one formula at a time by selecting the cell and looking in the formula bar. But what if you want to see every formula at once? Bring on Show Formulas mode.
Excel Shortcuts - Select Whole Column/Row »
August 10, 2017
Excel offers some fast ways to select the whole column or row based on the currently active cell. Today, you will see how to remember each keyboard shortcut.
Excel Shortcuts - Add to Selection »
August 9, 2017
Add to Selection in Excel. How to use Shift+F8 in Excel to Add to Selection.
Excel Shortcuts - Formula AutoComplete »
August 8, 2017
Why does Excel offer a function name without letting me select the function I want? When I start to type =VLOO in Excel, they know that I want VLOOKUP and even show me VLOOKUP. But how do I select it? Enter returns an error.
