Skip to content

Microsoft Excel

Is a spreadsheet Software, part of Microsoft Office,

Startup option

  • Safe mode: hold CTRL key
  • New instance: hold ALT key

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 ... />. This is usually just before </sheetData>
  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
  • New line in a formula: CHAR(10)

M