Melissa Compton (@MelComTech) header
Melissa Compton (@MelComTech) profile picture

Microsoft MVP Microsoft 365 • LibreOffice Automation • Business Intelligence • Productivity Tutorials • Templates • Courses

Lexington, KY
Joined September 2023
Still using Ctrl+K to create hyperlinks in Microsoft Word? There's an easier way! Copy a website URL, highlight your text, and press Ctrl+V. That's it! Ctrl+K still works, but this shortcut is faster. #MicrosoftWord #Microsoft365 #WordTips
27
Still filtering Excel tables with drop-downs? Use Slicers for cleaner, faster filtering. #Excel #MicrosoftExcel #ExcelTips #Data
32
Deleting blank rows one at a time? Don’t. Use Go To Special → Blanks → Delete Entire Row. Done in seconds. #Excel #ExcelTips #Productivity
1
14
Manually bolding totals? Hard-coding row numbers? There’s a better way. Automatically bold totals in Excel and build a dynamic SUM that won’t break when rows move. #Excel #ExcelTips #ConditionalFormatting #Spreadsheet
12
Paste Special not working in Excel? Greyed out or shortcut won’t open? Here’s a full troubleshooting guide covering clipboard state, protection settings, add-ins, and VBA conflicts. Watch here: youtu.be/-GtA23bz4Y4 #Excel #MicrosoftExcel #PasteSpecial #ExcelTips #Microsoft365
20
Stop manually numbering rows in Excel. Use SEQUENCE for ranges or a Table + ROW formula for stable, auto-updating numbering that adjusts when rows are added or deleted. #Excel #MicrosoftExcel #ExcelTips #Excel365
13
Excel removing leading zeros? Use custom number formatting to keep IDs and invoice numbers intact. #Excel #ExcelTips #Microsoft365
10
Model or Mess? Here’s how to design structured Excel models that are clear, consistent, and safe to hand off — plus a practical audit checklist. Template available on website. Watch →youtu.be/bm9iAzs6NKY #Excel #SpreadsheetDesign #BusinessExcel #Microsoft365
28