Visual Basic for Applications (VBA)

Articoli su Visual Basic for Applications (VBA) (6)

• Come bloccare le celle in Excel: proteggere le formule, consentire l'input
  2026-11-12 · Mirko Peters
  Come bloccare le celle in Excel: sblocca le celle di input, poi usa Revisione, Proteggi foglio. Inoltre nascondi le formule, consenti la modifica di intervalli specifici e risolvi
• Come rimuovere i duplicati in Excel: comando, formule, Power Query
  2026-11-12 · Mirko Peters
  Come rimuovere i duplicati in Excel: usa Dati, Rimuovi duplicati oppure conserva i dati originali con UNIQUE, formule e Power Query. Passaggi, limiti ed errori da evitare.
• Come scoprire tutte le righe in Excel (compresa la riga 1)
  2026-11-12 · Mirko Peters
  Come scoprire tutte le righe in Excel: seleziona l'intero foglio, poi Home, Formato, Nascondi o scopri, Scopri righe. Inoltre la riga 1, le righe filtrate, una macro e i casi ostin
• How to Unhide All Rows in Excel (Including Row 1)
  2026-11-12 · Mirko Peters
  How to unhide all rows in Excel: select the whole sheet, then Home, Format, Hide & Unhide, Unhide Rows. Also row 1, filtered rows, a macro and stubborn cases.
• How to Remove Duplicates in Excel: Command, Formulas, Power Query
  2026-11-12 · Mirko Peters
  How to remove duplicates in Excel: use Data, Remove Duplicates, or keep the original data with UNIQUE, formulas and Power Query. Steps, limits and mistakes.
• How to Lock Cells in Excel: Protect Formulas, Allow Input
  2026-11-12 · Mirko Peters
  How to lock cells in Excel: unlock the input cells, then use Review, Protect Sheet. Also hide formulas, let people edit set ranges, and fix common problems.