Come Usare la Funzionalità "Trova e Sostituisci" su Excel (PC o Mac)

Scarica PDF

Co-redatto da Lo Staff di wikiHow

Scarica PDF

In questo Articolo:

Windows

macOS

Articoli Correlati

Questo articolo insegna a cercare e a sostituire stringhe di testo su Microsoft Excel usando un computer con sistema operativo Windows o macOS.

Passaggi

Metodo 1

Metodo 1 di 2:

Windows

1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/20\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-1.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-1.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/20\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-1.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-1.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
   1
   Apri Microsoft Excel. Si trova generalmente nella sezione "Tutti i programmi" del menu

   

   {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/0\/07\/Windowsstart.png","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/07\/Windowsstart.png\/30px-Windowsstart.png","smallWidth":460,"smallHeight":460,"bigWidth":30,"bigHeight":30,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

   .
2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/67\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-2.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/67\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-2.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-2.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
   2
   Clicca sul file che vuoi modificare. Il documento verrà aperto con Excel.
3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/52\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-3.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/52\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-3.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-3.jpg","smallWidth":460,"smallHeight":341,"bigWidth":728,"bigHeight":540,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
   3
   Clicca su Trova e seleziona. Questo pulsante è raffigurato da una lente di ingrandimento e si trova nell'angolo in alto a destra. Apparirà un menu a discesa.
4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/fb\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-4.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fb\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-4.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-4.jpg","smallWidth":460,"smallHeight":343,"bigWidth":728,"bigHeight":543,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
   4
   Clicca su Trova. Questa opzione si trova in cima al menu a discesa. Si aprirà una finestra intitolata "Trova e sostituisci".
5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/21\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-5.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/21\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-5.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-5.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
   5
   Clicca sulla scheda Sostituisci. Si trova nella parte superiore della finestra pop-up.
6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/09\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-6.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/09\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-6.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-6.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
   6
   Digita il testo che desideri trovare. Assicurati di non inserire spazi aggiuntivi, in quanto questo inciderà sulla ricerca.
7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/aa\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-7.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-7.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/aa\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-7.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-7.jpg","smallWidth":460,"smallHeight":341,"bigWidth":728,"bigHeight":540,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
   7
   Inserisci il testo sostitutivo. Questo testo sostituirà quello che hai inserito nel primo campo.
8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/89\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-8.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-8.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/89\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-8.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-8.jpg","smallWidth":460,"smallHeight":341,"bigWidth":728,"bigHeight":540,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
   8
   Clicca su Opzioni per personalizzare la sostituzione. In questa sezione è possibile decidere se distinguere fra maiuscole e minuscole, cercare solo testo formattato in un certo modo, cercare dati specifici all'interno di formule e così via. È possibile saltare questo passaggio nel caso in cui tu voglia soltanto sostituire un testo standard con un testo altrettanto normale.
9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/1f\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-9.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-9.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1f\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-9.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-9.jpg","smallWidth":460,"smallHeight":350,"bigWidth":728,"bigHeight":554,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
   9
   Clicca su Sostituisci tutto o Sostituisci. Seleziona "Sostituisci tutto" per effettuare automaticamente la sostituzione in tutto il documento. In alternativa, clicca su "Sostituisci" per eseguire solo la prima sostituzione. Se selezioni quest'ultima opzione, dovrai cliccare su "Trova successivo" per vedere l'occorrenza successiva. Poi, clicca su "Sostituisci".
   Pubblicità

Metodo 2

Metodo 2 di 2:

macOS

1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/26\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-10-Version-2.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-10-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/26\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-10-Version-2.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-10-Version-2.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":548,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
   1
   Apri Microsoft Excel. Questo programma si trova solitamente nella cartella "Applicazioni" o nel Launchpad.
2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/8d\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-11-Version-2.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-11-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8d\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-11-Version-2.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-11-Version-2.jpg","smallWidth":460,"smallHeight":343,"bigWidth":728,"bigHeight":543,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
   2
   Clicca sul file che desideri modificare. Il documento verrà aperto con Excel.
3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/4c\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-12-Version-2.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-12-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4c\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-12-Version-2.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-12-Version-2.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":548,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
   3
   Clicca sul menu Modifica. Si trova in cima allo schermo.
4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/fe\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-13-Version-2.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-13-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fe\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-13-Version-2.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-13-Version-2.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
   4
   Clicca su Trova.
5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/fe\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-14-Version-2.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-14-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fe\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-14-Version-2.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-14-Version-2.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
   5
   Clicca su Sostituisci.
6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/54\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-15-Version-2.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-15-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/54\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-15-Version-2.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-15-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
   6
   Digita il testo che desideri trovare. Assicurati di non immettere spazi aggiuntivi, altrimenti incideranno sulla ricerca.
7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/cc\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-16-Version-2.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-16-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/cc\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-16-Version-2.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-16-Version-2.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
   7
   Inserisci il testo sostitutivo. Questo testo sostituirà quello che hai inserito nel primo campo.
8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3f\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-17-Version-2.jpg\/v4-460px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-17-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3f\/Find-and-Replace-on-Excel-on-PC-or-Mac-Step-17-Version-2.jpg\/v4-728px-Find-and-Replace-on-Excel-on-PC-or-Mac-Step-17-Version-2.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
   8
   Clicca su Sostituisci tutto o Sostituisci. Seleziona "Sostituisci tutto" per realizzare automaticamente le sostituzioni in tutto il documento. Seleziona invece "Sostituisci" per fare solo la prima sostituzione. In questo caso, dovrai cliccare su "Trova successivo" per vedere l'occorrenza seguente e poi cliccare su "Sostituisci".
   Pubblicità