Link Search Menu Expand Document

Microsoft Office

Excel

Excel UI

  • Move the cursor in a selection box: F2
  • Select only visible cells: Alt + ;

Un-hide all tabs

Alt+F11 for VBA F5 for execution

Sub UnhideAllSheets()
    Dim ws As Worksheet
 
    For Each ws In ActiveWorkbook.Worksheets
        ws.Visible = xlSheetVisible
    Next ws
 
End Sub

Remove a password on a protected sheet

  1. Open the XLSX as a ZIP
  2. Navigate to xlworksheets
  3. Edit the sheet, if trouble to find it: search for sheetProtection
  4. Remove everything between <sheetProtection ... />
  5. Save the sheetX.xml file in the XLSX and reopen the Excel!

Data

  • Date & Time: convert UNIX epoch to Excel format → (A1/86400)+25569+(-5/24) with A1 the data cell
  • Data validation: List without a Range → Use comma: xx,yy,zz

PowerQuery / PowerBI

  • Comment: // or /* and */
  • Library: =#shared
  • Define PK: Table.AddKey

Word

Word UI

  • Show Fields code: Shift-F9

Outlook

Calendar

  • Clear “Recent Location” drop-down list → Delete keys in: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Outlook\Preferences\LocationMRU

PowerPoint

Toolbar

Master slides

  • Change default slide when creating new slide: put this slide as the 3rd item in the master view. Source