Cheat Sheet
| Filter Buttons | 1. Highlight data 2. Ctrl + T (Makes it a table) 3. Alt + N + S + F (Add Slicer/Filter) 4. Select what data to use as filter buttons 5. Adjust columns with button options in ribbon to account for button object length |
| Highlight row automatically on cell select | 1. Highlight all data 2. Conditional Formatting Menu 3. Use Custom Formula 4. =ROW()=CELL(“ROW”) 5. Choose your formatting 6. Develop Tab and View Code 7. Select Worksheet 8. In between the code lines insert “Target.calculate” – close windows and done. |