One of the lesser-known keyboard shortcuts is also one of the most versatile. I am speaking of the enigmatic F4 key. At its core, the F4 key simply repeats the last action you performed in the program. Whether invoking a simple bold action in Word, deleting a row in Excel, or inserting a shape object […]
Microsoft Office – Quick Access Toolbar (Awesome “Hidden” Feature)
When Microsoft Office 2007 switched from the traditional dropdown menus and toolbars method of delivering program features to the now widely used Tabs and Ribbon delivery system, one of the abilities they revoked from the users was the ability to customize the program controls. Knowing that they (Microsoft) would have angry hoards with torches and […]
Excel – The BEST Dynamic Data Validation Dropdown List
Excel Data Validation lists are a great way to expedite data entry ensure consistent data entry reject undesirable information One of the few and far between shortcoming of Data Validation lists is the fact that with long lists, they have to exist somewhere in the workbook. The existing list supplies the entries displayed when the […]
Automatically Refresh Pivot Tables in Excel
Excel PivotTables are one of the greatest tools in the spreadsheet user’s toolkit. However, there is one tiny bit of functionality that appears to be missing: the ability of pivot tables to automatically update when information in the source data changes. Most user’s see this as a glaring lack of functionality. There is, however a […]